i have created a macro that asks the user to input the name of the product they are going to work with, but there are only 4 products, so i want the user to be able to enter only these 4 products in the input box, how do i do that??
because wenever they make a spelling mistake or the enter it in the wrong case the macro will trigger an infinite loop !
Hi
Post an excel file with the product names.
Click *, if my suggestion helps you. Have a good day!!
Hi, Suraj3825,
maybe you can work with Data/Validation in a cell on a worksheet and read the name of the product from there? Otherwise I would recommend a UserForm with either OptionButoons or a ComboBox for making the choice.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks