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?
x = InputBox("Enter changing cells, for example: $P$10,$P$11", "Changing Cells", "$P$10,$P$11")
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
set myrange = application.InputBox(Prompt:="Select changing cells", title:="Changing Cells", type:=8)
Josie
if at first you don't succeed try doing it the way your wife told you to
Try this:
Set x = Application.InputBox("Select cells", "Selection", , , , , , 8)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks