Hello,
I am trying to force entry into a user form after a comman button OKclick which performs a series of functions.
If a textbox is empty I want a msgbox to pop up telling the user to please enter "name" for example. When using If txtname.value = "" then msgbox"please enter a name" after the message box ok button is clicked the macro continues. Ideally the sub should end or "pause" and a pH value entered, forcing the user to click the commandbuttonOk again. Please let me know if you can help! Thank you for your time.
I am trying to force entry into a user form after a comman button OKclick which performs a series of functions.
If a textbox is empty I want a msgbox to pop up telling the user to please enter "name" for example. When using If txtname.value = "" then msgbox"please enter a name" after the message box ok button is clicked the macro continues. Ideally the sub should end or "pause" and a pH value entered, forcing the user to click the commandbuttonOk again. Please let me know if you can help! Thank you for your time.