importing values from excel to a custom form

  • Thread starter Thread starter sparkle_guy
  • Start date Start date
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
 
Back
Top