Command button to request user input (selection) of a range of cells
I wish to create a macro for a command button that requests user input of an range of cells in the active worksheet by selecting the cells with the mouse. The macro then prompts the user to select one of 3 option buttons and colors the user selected cells based on the setting of the 3 option buttons.
Thank you for any assistance.
Welcome to the Forum.
See if this code does what you need.
Rather than option buttons, which require a custom userform, I have used the built-in input box with a prompt to enter a number corresponding to a color choice.
Please Login or Register to view this content.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks