userforms

R

R

Hi,

I need to create a form that references specific cells from 5 different
workbooks. Also I want to be able to change referenced cell values through
the user form. Can anyone help me get started?

Thanks,

R.
 
T

Tushar Mehta

What in the userform (I assume you mean userform when you refer to form)
will be updated with the specific cell?

Whatever it is, start with one of them. I'll assume it is a textbox.
Use the userform's Initialize (or Activate) event to update the content
of the textbox. Something like the untested

Me.Textbox1.Text=workbooks("xyz").worksheets("abc").range("d34").value

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2004
 
R

R

Thanks. This will help.

-R
Tushar Mehta said:
What in the userform (I assume you mean userform when you refer to form)
will be updated with the specific cell?

Whatever it is, start with one of them. I'll assume it is a textbox.
Use the userform's Initialize (or Activate) event to update the content
of the textbox. Something like the untested

Me.Textbox1.Text=workbooks("xyz").worksheets("abc").range("d34").value

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2004
Click to expand...
 
Top