tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
The sheet is "Raw" and the range is AB21:AB300
i need a macro that is triggered when someone selects one of the following options from a dropdown box
Option 1
Option 2
Option 3
Option 4
Option 5
So heres what i need,
If some selects any ofther data from the dropdown box in the above range do nothing,
if they select one on the 5 options above then
open an input box Saying "Please Name This Section?"
and an input area to type a tile like "home"
then whatever they type get put into the cell they selected the dropdown in?
hope thats clear,
please help if you know how to do this
Thanks
Tony
The sheet is "Raw" and the range is AB21:AB300
i need a macro that is triggered when someone selects one of the following options from a dropdown box
Option 1
Option 2
Option 3
Option 4
Option 5
So heres what i need,
If some selects any ofther data from the dropdown box in the above range do nothing,
if they select one on the 5 options above then
open an input box Saying "Please Name This Section?"
and an input area to type a tile like "home"
then whatever they type get put into the cell they selected the dropdown in?
hope thats clear,
please help if you know how to do this
Thanks
Tony