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

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

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

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

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." <(E-Mail Removed)> wrote in message
news:1A5B8954-6CC8-4E69-ADCA-(E-Mail Removed)...
> 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