Checking for empty textbox and setfocus the empty textbox

**subbby** · 05-23-2013, 11:27 AM

Want the command button to check if any of the many textboxes in a userform are empty.

If empty, Want the macro to

setfocus on that textbox
Message box (pls enter the value)

tried this

Please Login or Register  to view this content.

Problem :

Doesn't setfocus the empty textbox

**JieJenn** · 05-23-2013, 11:31 AM

Can you post your file.

**subbby** · 05-23-2013, 11:34 AM

Originally Posted by JieJenn

Can you post your file.

Pls find it attached.

Thanks

**JieJenn** · 05-23-2013, 12:02 PM

Change your code to

Please Login or Register  to view this content.

**subbby** · 05-23-2013, 01:14 PM

I have many textboxes. In the actual spreadsheet, I have too many textboxes and I cant individually check as per your approach .

is there a way to check all and the setfocus on the first one it comes across and which is empty ?

**JieJenn** · 05-23-2013, 02:23 PM

Try this then

Please Login or Register  to view this content.

**subbby** · 05-23-2013, 02:49 PM

So its a COMBO BOX... not a textbox....

Thank you very much for your help. that worked

Checking for empty textbox and setfocus the empty textbox

LinkBack

Thread Tools

Rate This Thread

Display

Checking for empty textbox and setfocus the empty textbox

Re: Checking for empty textbox and setfocus the empty textbox

Re: Checking for empty textbox and setfocus the empty textbox

Re: Checking for empty textbox and setfocus the empty textbox

Re: Checking for empty textbox and setfocus the empty textbox

Re: Checking for empty textbox and setfocus the empty textbox

Re: Checking for empty textbox and setfocus the empty textbox

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions