importing values from excel to a custom form

S

sparkle_guy

Anyone got any ideas about the syntax to use in VBScript that can be used
used to copy values from an open excel sheet to textboxes on a custom form?

Have tried

Myform.textbox1 =
Application.workbooks("Myworkbook").worksheets("Myworksheet").cells(row,colu
mn) but without much luck.

Any suggestions gratefully appreciated thanks in advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
importing Access via code 0
Macros disabled in custom Outlook form 1
Writing multicolumn array data to a worksheet range 6
Where to publish my custom form ? 4
Problems with custom forms.. 1
Importing Contacts Does Not Use Defined Custom Form in Outlook 2007 1
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0

Top