Hi, as stated in title, I need to macro an inputbox to let me select cells instead of prompt me to enter cells.
For example, I need to select cells in column P, but number of rows is different everytime, eg. sometimes I want P10:P11 or P10,P12,P14....
my current code just allow me to enter cells, how should I modify the code to select the cells instead of typing it?
Please Login or Register to view this content.
Thanks for any replies!!!!
Probably a userform would be necessary for this. You could apply ranges to buttons (just as an example) and when the user selects a range the code can do whatever to that range.
If you ranges will change, I don't see how the user will be able to select a range they want without actually entering the range. Of course, I may not be understanding you correctly either.
If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.
---Keep on Coding in the Free World---
perhaps
Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
Try this:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks