ExcelBanter - UserForm:Resume to ListBox1

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - UserForm:Resume to ListBox1 (https://www.excelbanter.com/excel-discussion-misc-queries/106066-userform-resume-listbox1.html)

damorrison

UserForm:Resume to ListBox1

I have this code in a TextBox in a UserForm.

If ListBox1.Value = "" Then
MsgBox "You need to Select Routes or Cuts"

I would like to then resume to ListBox1

Dave Peterson

UserForm:Resume to ListBox1

Maybe...

Me.ListBox1.SetFocus

damorrison wrote:

I have this code in a TextBox in a UserForm.

If ListBox1.Value = "" Then
MsgBox "You need to Select Routes or Cuts"

I would like to then resume to ListBox1

--

Dave Peterson

damorrison

UserForm:Resume to ListBox1

Excelant,
Thanks Dave
Works Great
Dave

Dave Peterson wrote:
Maybe...

Me.ListBox1.SetFocus

Dave Peterson

All times are GMT +1. The time now is 07:39 PM.