Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Do this to identify the error and then show a NEW userform to add your
desired controls Above the line that gets the error message put this On Error Goto ErrorHandler Somewhere else in the script type ErrorHandler: If Err.Number = 381 then userform.show ' Put you NEW userform name here exit sub 'Keep this if you want to terminate the userfrom here end if With this you will then need to create a NEW userform to accomodate the controls you require Let us know how you get on and If you have any trouble you can email me at -- Message posted via http://www.officekb.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dynamic top 20 list | Excel Discussion (Misc queries) | |||
Changing named Validation list to Dynamic list. | Excel Discussion (Misc queries) | |||
add to a dynamic list | Excel Programming | |||
add to a dynamic list | Excel Programming | |||
Dynamic list box | Excel Programming |