User Forms

[Guest]

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 Rech]

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
| 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

 

[Bob Phillips]

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)

 

[Tom Ogilvy]

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?

 

[Guest]

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]

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

--

HTH

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

 

[Guest]

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.