Transfer to Textbox on Userform based on Combobox selection

**ShakJames** · 11-07-2016, 06:54 AM

Hi all

I was wondering if someone could help me with this. I have a userform that needs to be completed by someone but what I want to do is based on the selection someone makes in a combobox for example 'Yes' this automatically will transfer them to specific textbox which needs to be completed next. Basically skipping any textboxes which don't need to be completed.

So if you think of it as when you're completing a questionnaire and it may ask you to skip to question 6 depending on what you put in a particular box in question 1.

I hope this makes sense.

Thanks all!

**PFDave** · 11-07-2016, 06:58 AM

Maybe you could use a message box trigger by change event?

Please Login or Register  to view this content.

**ShakJames** · 11-07-2016, 07:05 AM

Hi Dave

Thank you for the response. I originally did use that method but found people were filling boxes incorrectly, so was basically trying to make it more robust.

Sorry should have said that I'd used a combobox method. What would be good if they pressed yes and it took them to the specific textbox as well.

**PFDave** · 11-07-2016, 07:17 AM

Why not combine it with

Please Login or Register  to view this content.

**ShakJames** · 11-07-2016, 07:22 AM

Good idea. I have actually just stumbled across something. I have used SetFocus and it seems to have done what I need. The code for anyone who might be interested is:

Please Login or Register  to view this content.

R13 is the name of the combobox and R19 the name of the textbox. I hope this will help someone.

Thanks for your help as well, Dave. Much appreciated.

**PFDave** · 11-07-2016, 07:25 AM

Glad you got it sorted.

Transfer to Textbox on Userform based on Combobox selection

LinkBack

Thread Tools

Rate This Thread

Display

Transfer to Textbox on Userform based on Combobox selection

Re: Transfer to Textbox on Userform based on Combobox selection

Re: Transfer to Textbox on Userform based on Combobox selection

Re: Transfer to Textbox on Userform based on Combobox selection

Re: Transfer to Textbox on Userform based on Combobox selection

Re: Transfer to Textbox on Userform based on Combobox selection

Thread Information

Users Browsing this Thread

Similar Threads

ComboBox values source being changed based on another combobox selection in a UserForm

Calculating/adding userform textbox values based on combobox selection and display to cell

[SOLVED] Userform textbox value based on combobox selection

[SOLVED] Excel Userform: Populate other controls (i.e. textbox & combobox) based on combobox select

[SOLVED] Fill a cell via textbox on userform depending on combobox selection

[SOLVED] How do I make a selection from a combobox on my VBA userform populate a textbox?

Find UserForm ComboBox Value (date) & Transfer TextBox Data To Same Row

Bookmarks

Bookmarks

Posting Permissions