userforms
 

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.

userforms
 

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

In article ,
says...
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.

userforms
 

Thanks. This will help.

-R
"Tushar Mehta" <tm_200310@tushar_hyphen_mehta_dot_see_oh_em wrote in
message om...
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

In article ,
says...
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.