Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Difficulties in VBA ( User form and option button)
Q1: I want to pass the value of a label in userform to a cell A2 in
the worksheet. how do i do it? Q2: I have a series of userforms. After the user completed a question in userform 1, Userform 2 will be loaded. I have difficulty in writing a code which aloows user to go back to Userform 1 to make changes. The program shows that the form can't be loaded modally. Can anyone help? Q3: Is there a way to ensure user must select from one of the option buttons available, such as if he did not select any, he will not be allow to proceed further? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Difficulties in VBA ( User form and option button)
Hi,
Q1 Use a textbox rather than a label control. Then for example Worksheets("Sheets1").Range("A2").Value = TextBox1.Value Q2. Sounds like you need a MultiPage control (from ToolBox) on ONE userform. The user can switch back and forth between the pages. No harder to initialise than a Userform. Q3. Put all the buttons inside a frame control (from ToolBox).Put on the frame control first, and the option buttons inside it. It will force the first option to be selected on loading and only allow one option to be chosen subsequently. regards Paul (paradise) wrote in message . com... Q1: I want to pass the value of a label in userform to a cell A2 in the worksheet. how do i do it? Q2: I have a series of userforms. After the user completed a question in userform 1, Userform 2 will be loaded. I have difficulty in writing a code which aloows user to go back to Userform 1 to make changes. The program shows that the form can't be loaded modally. Can anyone help? Q3: Is there a way to ensure user must select from one of the option buttons available, such as if he did not select any, he will not be allow to proceed further? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Difficulties in VBA ( User form and option button)
Q1
Worksheets("Sheets1").Range("A2").Value = label1.Caption will work as well. -- Regards, Tom Ogilvy "Paul Robinson" wrote in message om... Hi, Q1 Use a textbox rather than a label control. Then for example Worksheets("Sheets1").Range("A2").Value = TextBox1.Value Q2. Sounds like you need a MultiPage control (from ToolBox) on ONE userform. The user can switch back and forth between the pages. No harder to initialise than a Userform. Q3. Put all the buttons inside a frame control (from ToolBox).Put on the frame control first, and the option buttons inside it. It will force the first option to be selected on loading and only allow one option to be chosen subsequently. regards Paul (paradise) wrote in message . com... Q1: I want to pass the value of a label in userform to a cell A2 in the worksheet. how do i do it? Q2: I have a series of userforms. After the user completed a question in userform 1, Userform 2 will be loaded. I have difficulty in writing a code which aloows user to go back to Userform 1 to make changes. The program shows that the form can't be loaded modally. Can anyone help? Q3: Is there a way to ensure user must select from one of the option buttons available, such as if he did not select any, he will not be allow to proceed further? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User form and Command button | Excel Discussion (Misc queries) | |||
Controlling an Option Group in a User Form | Excel Discussion (Misc queries) | |||
In excel how do I delete an option button form already in worksht | Excel Discussion (Misc queries) | |||
use a button to open a user form? | Excel Discussion (Misc queries) | |||
A "previous" button on a user form | Excel Discussion (Misc queries) |