Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,494
Default 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



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 747
Default 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




  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,494
Default 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






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Optionbutton help Craig[_21_] Excel Programming 5 November 25th 05 10:04 PM
for each optionbutton masterphilch Excel Programming 1 September 21st 05 05:37 PM
OptionButton value Patrick Simonds Excel Programming 2 January 17th 05 10:50 AM
OptionButton nrage21[_70_] Excel Programming 0 September 29th 04 12:23 AM
Better Way to Use OptionButton [email protected] Excel Programming 0 September 1st 04 07:18 PM


All times are GMT +1. The time now is 05:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"