Cannot set the row property

[baha17]

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

 

[JLGWhiz]

I had trouble getting it to work with the command button on the sheet. But
it worked fine with the button on the userform.