| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List Box
I have a macro that looks for the value in a list box and then runs a set of
macros. I have the code to exit the Sub and display a message box if there isn't a value selected from the list box. If frmRefresh.ListBox3.Value = "" Then Exit Sub MsgBox "Select A Value from the List Box, vbOKOnly, "Error" Else Application.Run............................... End If It simply debugs later on because nothing is selected in the Listbox. I need the wording for the If statement to stop the macro if nothing is selected in the listbox. Thanks in advance |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
List Box
Try...
If Trim(frmRefresh.ListBox3.Value) = "" Then MsgBox "Select A Value from the List Box", vbOKOnly, "Error" Exit Sub Else Application.Run............................... End If -- If this post helps click Yes --------------- Jacob Skaria "N1KO" wrote: I have a macro that looks for the value in a list box and then runs a set of macros. I have the code to exit the Sub and display a message box if there isn't a value selected from the list box. If frmRefresh.ListBox3.Value = "" Then Exit Sub MsgBox "Select A Value from the List Box, vbOKOnly, "Error" Else Application.Run............................... End If It simply debugs later on because nothing is selected in the Listbox. I need the wording for the If statement to stop the macro if nothing is selected in the listbox. Thanks in advance |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
List Box
Hi Jacob,
Unfortunately it doesn't work, it brings up and error box with an invalid use of null. Thank you very much though. "Jacob Skaria" wrote: Try... If Trim(frmRefresh.ListBox3.Value) = "" Then MsgBox "Select A Value from the List Box", vbOKOnly, "Error" Exit Sub Else Application.Run............................... End If -- If this post helps click Yes --------------- Jacob Skaria "N1KO" wrote: I have a macro that looks for the value in a list box and then runs a set of macros. I have the code to exit the Sub and display a message box if there isn't a value selected from the list box. If frmRefresh.ListBox3.Value = "" Then Exit Sub MsgBox "Select A Value from the List Box, vbOKOnly, "Error" Else Application.Run............................... End If It simply debugs later on because nothing is selected in the Listbox. I need the wording for the If statement to stop the macro if nothing is selected in the listbox. Thanks in advance |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
List Box
strValue = frmRefresh.ListBox3.Text
If Trim(strValue) = "" Then MsgBox "Select A Value from the List Box", vbOKOnly, "Error" Exit Sub Else 'Application.Run............................... End If If this post helps click Yes --------------- Jacob Skaria "N1KO" wrote: Hi Jacob, Unfortunately it doesn't work, it brings up and error box with an invalid use of null. Thank you very much though. "Jacob Skaria" wrote: Try... If Trim(frmRefresh.ListBox3.Value) = "" Then MsgBox "Select A Value from the List Box", vbOKOnly, "Error" Exit Sub Else Application.Run............................... End If -- If this post helps click Yes --------------- Jacob Skaria "N1KO" wrote: I have a macro that looks for the value in a list box and then runs a set of macros. I have the code to exit the Sub and display a message box if there isn't a value selected from the list box. If frmRefresh.ListBox3.Value = "" Then Exit Sub MsgBox "Select A Value from the List Box, vbOKOnly, "Error" Else Application.Run............................... End If It simply debugs later on because nothing is selected in the Listbox. I need the wording for the If statement to stop the macro if nothing is selected in the listbox. Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use VBA to reset data validation (=list) value to first value in that list (list is a named range) | Excel Programming | |||
| Compare List A to List B, Return List B Items Not in List A | Excel Programming | |||
| validation list--list depends on the selection of first list | New Users to Excel | |||
| list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
| find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
Linear Mode
