importing values from excel to a custom form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sparkle_guy - 08 Jul 2004 21:17 GMT

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

Reply to this Message

Sue Mosher [MVP-Outlook] - 18 Jul 2004 21:58 GMT

Myform.UserProperties("name of property") is the correct syntax for an
Outlook property. See http://www.outlookcode.com/d/propsyntax.htm

Signature

Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> 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

Reply to this Message