excel - VBA Help - Need to return a text from a specific cell to a OptionButton -


i need return text specific cell , if text matches configuration of optionbutton, option button set true.

i tried use code bellow:

dim texto1 string texto1 = "testando texto" if range("d3").value = texto1     optionbutton1.value = true end if 

for option button (form control on sheet):

activesheet.shapes("option button 1").controlformat.value = true 

for option button (activex control on sheet):

activesheet.optionbutton1.value = true 

for option button (on form):

me.optionbutton1.value = true 

fyi: can use me.optionbutton1.caption = string if wanted in question's title.


Comments

Popular posts from this blog

ruby on rails - RuntimeError: Circular dependency detected while autoloading constant - ActiveAdmin.register Role -

c++ - OpenMP unpredictable overhead -

javascript - Wordpress slider, not displayed 100% width -