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
Post a Comment