Option Button Caption to be picked from Cell Value

[ateebali]

Dear Sir
I just need a way out that option button caption / name should be pick from cell values;

Like option button 1 should be linked with Cell A1 accordingly Option Button 7 linked with Cell A7

When we changed values in cell, option button caption may also be changed.

Regards

 

[My Aswer Is This]

Is this part of a vba script your working on?
What type Option button?

A Userform Option Button
A Activex Option Button
A Form control Option Button

Would you like to explain what your ultimate goal is?

 

[RoryA]

Please read the forum rules on cross-posting and comply with them in future. This is not the first time you have cross-posted without providing links and if you keep doing it, you are liable to have your posting privileges removed.

Cross posted here: https://chandoo.org/forum/threads/option-button-caption-to-be-picked-from-cell-vlue.40521/

 

[ateebali]

Yes sir need vb code, i will link it with button

It is A Form control Option Button
I want to link this with Cell Values for example, Sheet2 Range A1:A10
When There is value in A1
Option Button 1 caption to be changed to Cell Value A1
Similarly Option Button 10 caption to be changed / linked with cell value a10

If cell values is A1:A2 only two option button should be displayed
If cell values is A1:A8, all 08 values to be displayed in option button

 

[ateebali]

Note and will take care