Just starting with user forms

[JimM]

Hi guys

Just starting to look at user forms !!

I've seen a couple of tutorials etc that show how to use user forms to populate a spreadsheet but can I want to use one to display info lifted from a spreadsheet.

Just to get me started can someone tell me how I could get a user form to display the contents of cell A1 from a given spreadsheet or point me towards a tutorial that covers this

Thanks

Jim

 

[bertie]

Hi Jim,

The design of this site is sore on the eyes. But the first tutorial in the list, Build a UserForm for Excel may be what you are looking for. There is also a pdf file you can download.

http://pdf.tinnier.com/books/Excel_Userform_Pdf.html

Hope this helps.
Bertie

http://pdf.tinnier.com/Read/_vp.d3d3LmZvbnRzdHVmZi5jb20-_vp..sl_ebooks.sl_free.sl_fsUserForms.pdf

 

[Ruddles]

At its simplest, assuming you've already created a text box called TextBox1 on the user form, right-click the background of the user form and select UserForm and Initialize from the drop-downs, add this line to the UserForm_Initialize event handler:-

TextBox1 = Range("A1")

Now run the user form by pressing F5 or clicking the green 'run' triangle.

Yes?

(I've coded Range("A1") but you need to make sure you're actually looking at the correct workbook and worksheet at all times.)

Now change that to:-

TextBox1 = Range("A1")
Range("B1")=TextBox1.Value * 2

and run the form again. Check the contents of cell B1.

Finally create a second text box called TextBox2 and also a command button, right-click the command button and View Code. In the event handler it creates - probably called CommandButton1_Click - add this code:-

TextBox2 = TextBox1.Value * 99

and run the form again. Check the contents of the second text box.

Get the idea?