I have this code
I keep getting a error and when I debut it highlights this line - .OLEObjects(sCOMBOBOX_PREFIX & i).Object.Value = vbNullStringHTML Code:
I have attached a sheet the VBA password is Kayley98 jippy.xlsm
I have this code
I keep getting a error and when I debut it highlights this line - .OLEObjects(sCOMBOBOX_PREFIX & i).Object.Value = vbNullStringHTML Code:
I have attached a sheet the VBA password is Kayley98 jippy.xlsm
I can't find where "wksLog" is set in your sub. And Excel will not call the error when it run the line of code :
but it will when you use .OLEObject within the WITH statement because wsklog is Empty.Please Login or Register to view this content.
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
this code was given to me to clear combo boxes, can you help with that?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks