aoz Posted February 2, 2007 Report Share Posted February 2, 2007 to all, I have captured demographics in 10 variables, T1 to T10 I have a Multiple Choice box, which displays their titles and their values. We capture the demotraphics from one medical system, and want to individually paste that person's values to another system (last name, first name, etc) Currently, my staff has to 1. start macro 2. select, in the multiple choice box, which value they want (last name, etc) (this pastes that value to the clipboard 3. right-click mouse in other progrm, in the field that is to recieve the data 4. either type "P" (for paste), or SELECT "P" (for paste) 4b - select OK, or whatever, in the destination program 5. go back to multiple choice box, select next item wanted, and repeat I'd like a way to have the macro detect that the "P" was either pressed (wait for keystroke), or more importantly, detect that the mouse left-clicked on a "P", for paste, and automatically load the clipboard with the next variable (if first name was just entered, then last name would be loaded) and the staff could go to the next field, left click to position the mouse, right-click to get mouse menu, and left-click on "P". The "P" woudl be the triggering factor to change clipboard values, because they might first go somewhere else on the screen. the MULTIPLE CHOICE box would not be too intolerable, except 1. it canot be resized 2 it cannot remain on top with focus this means that if the other program is in full screen mode, the multiple choice box disappears, and has to be selected from taskbar any feedback is appreciiated. Nick Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.