Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Click here to start participating now! Also, check out the New User Guide.
user input in a macro by using vba
Name: Joezhou Date: July 20, 2003 at 22:04:51 Pacific OS: xp CPU/Ram: xp
Comment:
What I am trying to do is to ask user to select several columns from one worksheets and then then copy it to another worksheet. This process is in the middle of one macro that I created. Which syntax I need to use to get the user input?
Name: A Certain TH Date: July 23, 2003 at 13:26:38 Pacific
Reply:
Several ways of doing this. None "simple".
Most sensible way is to use a form which allows users to select areas of a sheet via a RefEdit item. Other ways include asking user to manually input row/col references. Another way is to guess what they want copied, and ask them to confirm before doing so.
Why can't your macro work out which part will be chosen?
Summary: I think you could use a Dynamic Range Name to do this. I tried this and it seems to work. Assumptions: Dates are in A1:A31 Hours are in B1:B31 The first date you want to match is in C1 The last date ...
Summary: Hello, I would like to write a macro that makes a small window pop-up (similar to an InputBox) that requests the user inputs a fair amount of text (a paragraph, or more) and allows multiple lines. Thi...
0 
picture it
