Excel - Active X Combobox, Selecting Sheets
Solved/Closed
MRafik
Posts
24
Registration date
Wednesday January 9, 2013
Status
Member
Last seen
November 25, 2013
-
Jan 9, 2013 at 01:37 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 12, 2013 at 03:02 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 12, 2013 at 03:02 PM
Related:
- Excel - Active X Combobox, Selecting Sheets
- Mark sheet in excel - Guide
- Sheets right to left - Guide
- How to open excel sheet in notepad++ - Guide
- Excel apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jan 10, 2013 at 05:08 PM
Jan 10, 2013 at 05:08 PM
Try LostFocus event
or use keyupevent to look for enter key and then trigger
or use keyupevent to look for enter key and then trigger
Thank you very much
It does work
You are a star
Can you please help with what additional code I will
need to put in and were if a sheet does not exist
ie a Message Box displaying "NO SUCH SHEET EXISTS"
Once again THANK YOU
It does work
You are a star
Can you please help with what additional code I will
need to put in and were if a sheet does not exist
ie a Message Box displaying "NO SUCH SHEET EXISTS"
Once again THANK YOU
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jan 12, 2013 at 03:02 PM
Jan 12, 2013 at 03:02 PM
you can use this function to test if a sheet is present or not
Public Function isSheetPresent(sheetName As String) As Boolean Dim tempValue As String On Error Resume Next tempValue = "This is only a dummy value for test isSheetPresent." tempValue = Sheets(sheetName).Cells(1, 1) On Error GoTo 0 Err.Clear isSheetPresent = (tempValue <> "This is only a dummy value for test isSheetPresent.") End Function
Jan 11, 2013 at 01:47 PM
Tried putting the code in both the
Lost focus and the keyup events
But can not resolve the problem
Any other ideas
Jan 11, 2013 at 05:28 PM