if inputbox is emtpy , and 'enter' is presed, then exit

**chubbychub** · 04-28-2023, 06:25 PM

I have the below code on a userform, when I pressed enter (if inputbox 'squaretotal' is empty, then it bring out the debugger.

Please Login or Register  to view this content.

**mjr veverka** · 04-28-2023, 06:53 PM

?

Please Login or Register  to view this content.

**chubbychub** · 04-28-2023, 07:14 PM

I tried that but may be its not that part of the code, i have attached a sample workbook and in this line is where the debugger comes highlighted:

Please Login or Register  to view this content.

everything else works fine, its just when pressing "Enter" and the inputbox 'SquareTotal' if its empty it bring out the debugger, and i just want it to exit userform or messagebox only if its emtpy.

**mjr veverka** · 04-29-2023, 04:38 AM

What exactly is the problem described in this topic ?

**chubbychub** · 04-29-2023, 04:57 PM

if inputbox 'SquareTotal' is empty, and 'enter' is pressed, it gives error (bring out the debugger)
i want it to if value is empty, and enter is press, to give out a messagebox

if inputbox is emtpy , and 'enter' is presed, then exit

LinkBack

Thread Tools

Rate This Thread

Display

if inputbox is emtpy , and 'enter' is presed, then exit

Re: if inputbox is emtpy , and 'enter' is presed, then exit

Re: if inputbox is emtpy , and 'enter' is presed, then exit

Re: if inputbox is emtpy , and 'enter' is presed, then exit

Re: if inputbox is emtpy , and 'enter' is presed, then exit

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Exit Sub When Cancel for 1 * InputBox

[SOLVED] Exit Sub When Cancel on InputBox

inputbox exit is blank

[SOLVED] Vba to exit sub on cancel on inputbox

[SOLVED] Exit Sub on InputBox Cancel

Use Inputbox value to exit sub problem

Clean Exit from InputBox

Bookmarks

Bookmarks

Posting Permissions