Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I get input from an edit box to a worksheet?
I have been trying to get edit box input from the dialog box to my control
sheet and am stuck. I have done this before but it may have been on an earlier version of excel. Here's what I thought I could do: Range("FirstNameBox").Text = Sheets("control").Range("FirstName").Text Where "FirstNameBox" is the named range for the edit box on the dialog sheet. What am I doing wrong? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I get input from an edit box to a worksheet?
In the VBA menu select view Properties windows and Project Manager. click
your form on the Prohject Manager window. Check the names of your forms. the command you should be using is similar to this Range("FirstNameBox").Text = Userform1.refedit1.text "Brendan B." wrote: I have been trying to get edit box input from the dialog box to my control sheet and am stuck. I have done this before but it may have been on an earlier version of excel. Here's what I thought I could do: Range("FirstNameBox").Text = Sheets("control").Range("FirstName").Text Where "FirstNameBox" is the named range for the edit box on the dialog sheet. What am I doing wrong? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I get input from an edit box to a worksheet?
Thanks. I'm working with an Excel 5.0 dialog box though--does this make a
difference? (Not using a userform...newbie...) Thanks again. "Joel" wrote: In the VBA menu select view Properties windows and Project Manager. click your form on the Prohject Manager window. Check the names of your forms. the command you should be using is similar to this Range("FirstNameBox").Text = Userform1.refedit1.text "Brendan B." wrote: I have been trying to get edit box input from the dialog box to my control sheet and am stuck. I have done this before but it may have been on an earlier version of excel. Here's what I thought I could do: Range("FirstNameBox").Text = Sheets("control").Range("FirstName").Text Where "FirstNameBox" is the named range for the edit box on the dialog sheet. What am I doing wrong? Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I get input from an edit box to a worksheet?
Never did this with 5.0. Is 5.0 part of Offfice 97. If it is I know therre are siggnificant differences. "Brendan B." wrote: Thanks. I'm working with an Excel 5.0 dialog box though--does this make a difference? (Not using a userform...newbie...) Thanks again. "Joel" wrote: In the VBA menu select view Properties windows and Project Manager. click your form on the Prohject Manager window. Check the names of your forms. the command you should be using is similar to this Range("FirstNameBox").Text = Userform1.refedit1.text "Brendan B." wrote: I have been trying to get edit box input from the dialog box to my control sheet and am stuck. I have done this before but it may have been on an earlier version of excel. Here's what I thought I could do: Range("FirstNameBox").Text = Sheets("control").Range("FirstName").Text Where "FirstNameBox" is the named range for the edit box on the dialog sheet. What am I doing wrong? Thanks |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I get input from an edit box to a worksheet?
Since you can't (or it is difficult) to put an edit box on a worksheet, by
Excel 5.0 dialog box, I assume you mean dialogsheet. I am guessing this is what you want: Sheets("Control").Range("FirstName").Value = _ DialogSheets("Dialog1").EditBoxes("FirstNameBox"). Value Replace "Dialog1" with the name of your dialog sheet Replace "FirstNameBox" with the name of your edit box. You can't assign anything to the TEXT property of a range - it is read only. You have to use the VALUE property. -- Regards, Tom Ogilvy "Brendan B." wrote in message ... Thanks. I'm working with an Excel 5.0 dialog box though--does this make a difference? (Not using a userform...newbie...) Thanks again. "Joel" wrote: In the VBA menu select view Properties windows and Project Manager. click your form on the Prohject Manager window. Check the names of your forms. the command you should be using is similar to this Range("FirstNameBox").Text = Userform1.refedit1.text "Brendan B." wrote: I have been trying to get edit box input from the dialog box to my control sheet and am stuck. I have done this before but it may have been on an earlier version of excel. Here's what I thought I could do: Range("FirstNameBox").Text = Sheets("control").Range("FirstName").Text Where "FirstNameBox" is the named range for the edit box on the dialog sheet. What am I doing wrong? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Edit Worksheet Comments | Excel Worksheet Functions | |||
Can't edit worksheet | Excel Worksheet Functions | |||
Can't Edit Excel worksheet | Excel Discussion (Misc queries) | |||
Macro to edit text string data input | Excel Programming | |||
Input Form on Worksheet 1, Data on Worksheet 2 | Excel Programming |