Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Display active workbook in E-mail but do NOT send
I need to put my active workbook in an email but do not want to send it. Using ActiveWorkbook.SendMail always sends the workbook automatically. Thanks Osian- wakayama
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
How do I refer to an 'empty' listbox in VBA code?
Hi - my program runs using a number of listboxes that only allow users to make single selections within each one. I basically want to show an error message if at least one of these listboxes haven't been selected, but not sure how to define 'empty' when referring to a listbox. I've tried If...- wakayama
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
VBA On Error handling - jump more than one line of code on error
I want my programme to jump to Err 1 when it detects an error in this loop, but this doesn't seem to be working (i.e. I still get run-time error message '13'). Can anyone spot any problem with my syntax? Private Sub groups_Click() On Error Resume Next For i = 0 To 100...- wakayama
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
