How do I link a user form text box to a worksheet? What I need to do is
create a form entry for viewing, editting, adding, deleting rows of data on a
worksheet. Please assist. Thank you

Userform textboxes do not have a property that ties their values to
particular worksheet cells, so you'll need a macro to populate the userform,
e.g,:

TextBox1.Value = Range("A1").Value

--
Jim Rech
Excel MVP
"CindyK" wrote in message
...
| How do I link a user form text box to a worksheet? What I need to do is
| create a form entry for viewing, editting, adding, deleting rows of data
on a
| worksheet. Please assist. Thank you

Jim,
ControlSource property doesn't work for you? Worked for me in xl97 with a
textbox from the control toolbox toolbar on a userform. Are you talking
about something else?

--
Regards,
Tom Ogilvy

"Jim Rech" wrote in message
...
Userform textboxes do not have a property that ties their values to
particular worksheet cells, so you'll need a macro to populate the
userform,
e.g,:

TextBox1.Value = Range("A1").Value

--
Jim Rech
Excel MVP
"CindyK" wrote in message
...
| How do I link a user form text box to a worksheet? What I need to do is
| create a form entry for viewing, editting, adding, deleting rows of data
on a
| worksheet. Please assist. Thank you

The textbox has a link property, called ControlSource. Set that to the cell
reference.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"CindyK" wrote in message
...
How do I link a user form text box to a worksheet? What I need to do is
create a form entry for viewing, editting, adding, deleting rows of data
on a
worksheet. Please assist. Thank you

I can't use Control Source because I have many records and need to be able to
move between records on the screen. What I did was assign the starting
record in code behind the form but now I am trying to create command buttons
to move between the records (no luck yet). If anyone can help, please do.
Thanks

"Bob Phillips" wrote:

The textbox has a link property, called ControlSource. Set that to the cell
reference.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"CindyK" wrote in message
...
How do I link a user form text box to a worksheet? What I need to do is
create a form entry for viewing, editting, adding, deleting rows of data
on a
worksheet. Please assist. Thank you

Why don't you use the built-in data forms (DataForm...)?@

--

HTH

RP
(remove nothere from the email address if mailing direct)


"CindyK" wrote in message
...
I can't use Control Source because I have many records and need to be able
to
move between records on the screen. What I did was assign the starting
record in code behind the form but now I am trying to create command
buttons
to move between the records (no luck yet). If anyone can help, please do.
Thanks

"Bob Phillips" wrote:

The textbox has a link property, called ControlSource. Set that to the
cell
reference.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"CindyK" wrote in message
...
How do I link a user form text box to a worksheet? What I need to do
is
create a form entry for viewing, editting, adding, deleting rows of
data
on a
worksheet. Please assist. Thank you

Because the user can close this form easily and also I need to create flags
to check if the record was changed, deleted or added as new. I can do this
with custom command buttons and I don't believe I can modify the built in
data forms feature.

"Bob Phillips" wrote:

Why don't you use the built-in data forms (DataForm...)?@

--

HTH

RP
(remove nothere from the email address if mailing direct)


"CindyK" wrote in message
...
I can't use Control Source because I have many records and need to be able
to
move between records on the screen. What I did was assign the starting
record in code behind the form but now I am trying to create command
buttons
to move between the records (no luck yet). If anyone can help, please do.
Thanks

"Bob Phillips" wrote:

The textbox has a link property, called ControlSource. Set that to the
cell
reference.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"CindyK" wrote in message
...
How do I link a user form text box to a worksheet? What I need to do
is
create a form entry for viewing, editting, adding, deleting rows of
data
on a
worksheet. Please assist. Thank you