ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   optionbutton question (https://www.excelbanter.com/excel-programming/358168-optionbutton-question.html)

Gary Keramidas

optionbutton question
 
how would you concatenate a variable onto the end of optionbutton property?

so, say z = 1 to 4

me.optionbutton & z.caption = "Some text"

--


Gary




Greg Wilson

optionbutton question
 
Try:
Me.Controls("OptionButton" & z).Caption = "Some text"

Regards,
Greg

"Gary Keramidas" wrote:

how would you concatenate a variable onto the end of optionbutton property?

so, say z = 1 to 4

me.optionbutton & z.caption = "Some text"

--


Gary





Gary Keramidas

optionbutton question
 
thanks greg.

--


Gary


"Greg Wilson" wrote in message
...
Try:
Me.Controls("OptionButton" & z).Caption = "Some text"

Regards,
Greg

"Gary Keramidas" wrote:

how would you concatenate a variable onto the end of optionbutton property?

so, say z = 1 to 4

me.optionbutton & z.caption = "Some text"

--


Gary








All times are GMT +1. The time now is 04:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com