Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot set the row property
Hi All,
I have a userform which has a combobox,there is a code like userform1.initialize combobox1.rowsource=("pit") 'pit is a range name end sub and there is another code like optionbutton1_click combobox1.rowsource=("paiza") ' paiza is a range name end sub but if that worksheet open from web page(still in excel),once I click optionbutton i generates error.I really could not understand why the rest of the code is workin but cannot renew the source property.Everything works fine when I open the sheet as a normal excel file. Thanks for your help,and please do let me know If I could not explain clearly. Regards baha |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot set the row property
I had trouble getting it to work with the command button on the sheet. But
it worked fine with the button on the userform. " wrote: Hi All, I have a userform which has a combobox,there is a code like userform1.initialize combobox1.rowsource=("pit") 'pit is a range name end sub and there is another code like optionbutton1_click combobox1.rowsource=("paiza") ' paiza is a range name end sub but if that worksheet open from web page(still in excel),once I click optionbutton i generates error.I really could not understand why the rest of the code is workin but cannot renew the source property.Everything works fine when I open the sheet as a normal excel file. Thanks for your help,and please do let me know If I could not explain clearly. Regards baha |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Get Property value of class instance by passing string property name | Excel Programming | |||
Runtime error 380 - Could not set the list property. Invalid property value. | Excel Programming | |||
Could not set the ControlSource property. Invalid property value error | Excel Programming | |||
Runtime Error 380 – Could not set the list property. Invalid property value | Excel Programming | |||
Runtime error 380: Could not set the List property. invalid property value of listbox | Excel Programming |