I want to put a warning msg if the text boxes are empty

1 year ago 5 Replies

Maneesha Wijawardana 1 year ago

Hello
I want to put a warning msg if the text boxes are empty
That i i want them in a one msg like
enter :
fruit
name
country
i do not want it msg preview one by one
i want a vba code
i will send this workbooks
Please help me

0 Likes

Replies

Kaye Celine Legaspi 1 year ago

Put if else condition then on the msgbox vbcritical

0 Likes

Kaye Celine Legaspi 1 year ago

Try this If “name of listbox” = 0 then Msgbox “reason”, vbCritical, “Title of box” Else Condition or flow End if

0 Likes

Con Kosteas 1 year ago

If me. Textbox1. Value =“” then msgbox

0 Likes

Biplab Das 1 year ago

Maneesha Wijawardana Do You want When You click then Show Msgbox of Lable Caption against Empty TextBox.. Right?

1 Like

Sree Kumar 1 year ago

Vba developer here. If you need code pm me. Thanks

0 Likes

Relate Discussions

• Create Table for any number asked by someone !! Sub Table1() 5 Replies

• i have a userform to enter data in three text boxes and one combobox with a maximum number to 50 entry what i want is to show only one data row of three text boxes and one combobox and a button at the end of that 3 Replies

• Whenever I enter any data it should turn it yellow. 6 Replies

• I have been looking around the internet, fruitlessly (where’s the fruit? 29 Replies

• what is the thought on fruit smoothies? 15 Replies

• When ever I use sheet1.printpreview and that’s the only code I don’t get a print preview but I get a printed sheet 4 Replies

• I currently have: =TEXTJOIN("; ",TRUE,F3:J3) Essentially I have four excel boxes that I am trying to TEXTJOIN. 10 Replies

• I currently have: =TEXTJOIN("; ",TRUE,F3:J3) Essentially I have four excel boxes that I am trying to TEXTJOIN. 7 Replies

• can some one help me how to enable the auto real time data after press enter one time only. 3 Replies

• I want to combine all workbooks into one single workbook. 5 Replies