I want to be forced into typing in my userform textbox

[pwebley]

I have a custom dialog box (userform) that appears as soon as the workbook is opened. I want the user to HAVE to put a name in the text field and then click submit. If the textfield is blank when they click submit I want the custom dialog box to reappear asking them to do the same thing until something is typed and then they click submit. Any help will be appreciated. I already have the submit button programmed to enter the text into a specific cell.

 

[Trevor G]

Welcome to the forum,

Behind your command button add something like this

If textBox.value="" then
msgbox"Please enter data"
Me.TextBox1.SetFocus
else
'what you want it to do
end if

 

[pwebley]

Thanks for the quick response. I look forward to being on here more often. Now that I have a msg box that prompts me to enter text once I click okay on the msg both boxes disappear I have a userform1.hide command and I want that to stay but I only want it to hide after text has been submitted to the linked cell.

 

[Trevor G]

Change the order then

If textBox.value="" then
Me.TextBox1.SetFocus
msgbox"Please enter data"
else
'what you want it to do
end if

 

[pwebley]

Thanks for your help, everything works great now!

 

[Trevor G]

Nice to read you have a working solution.