| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
repost: How do I activate an option button?
I am reposting this questions because previous strng was getting long and the
original question might not have been clear. Let me start from the beginning. 1. Open a new book 2. Insert Option Button from Control Toolbox. I name it OptionButton1 and place it in cells D19-E20 3. Insert a second Option Button from Control Toolbox. OptionButton2 in cells D23-E24 4. Repeat step 3 for a third OptionButton3 in cells D27-E28 5. Go to OptionButton1, Right Click and under View Code, insert code: "Range("B8").Value = 1" 6. Go to OptionButton2, Right Click and under View Code, insert code: "Range("B8").Value = 2" 7. Go to OptionButton3, Right Click and under View Code, insert code: "Range("B8").Value = 3" What do I do next to be able to select either OptionButton1, 2 or 3? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
repost: How do I activate an option button?
I have found the answer. Thank you everyone.
"Formatting" wrote: I am reposting this questions because previous strng was getting long and the original question might not have been clear. Let me start from the beginning. 1. Open a new book 2. Insert Option Button from Control Toolbox. I name it OptionButton1 and place it in cells D19-E20 3. Insert a second Option Button from Control Toolbox. OptionButton2 in cells D23-E24 4. Repeat step 3 for a third OptionButton3 in cells D27-E28 5. Go to OptionButton1, Right Click and under View Code, insert code: "Range("B8").Value = 1" 6. Go to OptionButton2, Right Click and under View Code, insert code: "Range("B8").Value = 2" 7. Go to OptionButton3, Right Click and under View Code, insert code: "Range("B8").Value = 3" What do I do next to be able to select either OptionButton1, 2 or 3? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
repost: How do I activate an option button?
And that answer was????
Gord On Mon, 16 Mar 2009 14:26:01 -0700, Formatting wrote: I have found the answer. Thank you everyone. "Formatting" wrote: I am reposting this questions because previous strng was getting long and the original question might not have been clear. Let me start from the beginning. 1. Open a new book 2. Insert Option Button from Control Toolbox. I name it OptionButton1 and place it in cells D19-E20 3. Insert a second Option Button from Control Toolbox. OptionButton2 in cells D23-E24 4. Repeat step 3 for a third OptionButton3 in cells D27-E28 5. Go to OptionButton1, Right Click and under View Code, insert code: "Range("B8").Value = 1" 6. Go to OptionButton2, Right Click and under View Code, insert code: "Range("B8").Value = 2" 7. Go to OptionButton3, Right Click and under View Code, insert code: "Range("B8").Value = 3" What do I do next to be able to select either OptionButton1, 2 or 3? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I activate an option button? | Excel Discussion (Misc queries) | |||
| button in a cell to activate a macro | Excel Worksheet Functions | |||
| How do I activate right mouse button in Excel | Setting up and Configuration of Excel | |||
| how to activate the permission option in the file tab in excel? | Setting up and Configuration of Excel | |||
| keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) | |||
Linear Mode
