Need Help with VBA code that populates a dropdown in a userform conditionally

[seannormand]

Hello Excel Forum!

I have some VBA code that populates a userform based on text and named ranges. The userform is a survey for clients to take and it works great. The only problem is that it's set for 8 responses (a dropdown selection and text entry). It's really easy to change the question in the survey and the possible responses in the dropdown but the problem is if i want to go from 8 questions to 7 then I have to go in and delete a bunch of code because the code tells it to populate the userform based on text in certain places. What I would like is a conditional statement which says "if there is text in that cell then use it" if there isn't anything there no big deal. Here's what I have. I would really appreciate any help.

Thanks,

Please Login or Register  to view this content.

[xlbiznes]

you have to use an if statement , like this :

Please Login or Register  to view this content.

[seannormand]

Thanks xlbiznes but I couldn't get that to work. Basically I don't want to hard code "My Text" because I want to be able to easily change it. So if there is some text in C1 then

Please Login or Register  to view this content.

but if not then don't put anything in there.

Thanks,

[xlbiznes]

try this

Please Login or Register  to view this content.

[seannormand]

Thanks xlbiznes! I think your part worked but I came up with an error code because of the same problem on my combobox. Can this be made conditional like the above??

Please Login or Register  to view this content.

[xlbiznes]

try this

Please Login or Register  to view this content.

[seannormand]

clean survey.xlsm

I couldn't get it to work. I'm probably missing something simple...

[xlbiznes]

replace your Private Sub UserForm_Initialize() code with this and see what happens.

Please Login or Register  to view this content.

[zbor]

Opened in Commercial Services subforum so I'll close this one.