p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   VB How-To (http://p2p.wrox.com/forumdisplay.php?f=78)
-   -   Copy cell into userform? (http://p2p.wrox.com/showthread.php?t=66716)

Cabbage March 18th, 2008 06:51 AM

Copy cell into userform?
 
Hello,

I have a bill template that users enter narrative, amounts and VAT into a user form, that information is then displayed in a table format in the template ready to print.

I am trying to create a userform that will copy the narrative from main document in the selected cell and place the text into a textbox within a userform so that the user can edit?

Can anyone advise how I can go about this, or where I can look for this information, as I am really confused as to the correct syntax for this.

Many thanks,


BrianWren March 18th, 2008 11:03 AM

This starts a new sentence. Should be a period, followed by a capital letter:
"... user form, that information..." should be "... user form. That information..."

"I am trying to create a userform that will copy the narrative from main document in the selected cell and place the text into a textbox within a userform so that the user can edit" is a statement, not a question, and so should end with a period, not a question mark.

(Trying to be helpful...)

What environment does this apply to? Is this Excel? VB6? VB.NET? Access? Word (if so, which version)?

If you are using Word, the Selection object should have in it the data you are after.

The word you used, "main document," implies Word, but the description ",in the selected cell," seems to imply Excel. If you could clarify, that would be helpful.

Raghavendra_Mudugal April 29th, 2008 07:04 AM

Hello Cabbage!

Check this link;
http://in.geocities.com/raghavendra_...To_TextBox.zip

it will populates the two particular cells data to the userForm two respective textboxes.

Enter the Billamount in B3 and VAT in B4 and click that "call form" button.

Hope this will give you an idea.

With Regards,
Raghavendra Mudugal


All times are GMT -4. The time now is 03:17 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.