Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy TextBox Text
I have a userform with multiple textboxes , I want to be able to highlight
text in a text-box and hit a button which would essentialy copy the text string and based on which button I had clicked send it to the appropriate designated cell in a spreadsheet. If this is at all possible I would greatly appreciate any help or direction. Thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy TextBox Text
Something like:
Private Sub CommandButton1_Click() if textbox1.value <"" then with sheet1 ..select range("A1").value = textbox1.value else msgbox "There is NO Value in Textbox1 !!" end if end with end sub Changing Texbox1 to what ever you need and the Sheet1 & A1 to also suit. Corey.... "Benz" wrote in message ... I have a userform with multiple textboxes , I want to be able to highlight text in a text-box and hit a button which would essentialy copy the text string and based on which button I had clicked send it to the appropriate designated cell in a spreadsheet. If this is at all possible I would greatly appreciate any help or direction. Thank you. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy TextBox Text
Thank you Corey, but I was hoping it could copy just the selected string of
text within the text box and copy/Move it. Example: TextBox "This Useform is for the purpose of tracking parts, orders, and status." I was wondering if it is possible to select " part, orders and status" within the text box .... then hit the button and have just that phrase copy to a cell. "Corey" wrote: Something like: Private Sub CommandButton1_Click() if textbox1.value <"" then with sheet1 ..select range("A1").value = textbox1.value else msgbox "There is NO Value in Textbox1 !!" end if end with end sub Changing Texbox1 to what ever you need and the Sheet1 & A1 to also suit. Corey.... "Benz" wrote in message ... I have a userform with multiple textboxes , I want to be able to highlight text in a text-box and hit a button which would essentialy copy the text string and based on which button I had clicked send it to the appropriate designated cell in a spreadsheet. If this is at all possible I would greatly appreciate any help or direction. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy range Cell text and font properties to a Textbox | Excel Programming | |||
Copy/paste text in cells into a textbox | Excel Programming | |||
How can I copy formatted text from an Excel textbox into an IE .htm document ? | Excel Programming | |||
How to copy text from a TextBox in a ActiveSheet to a variable | Excel Programming | |||
How to copy text from a TextBox in a ActiveSheet to a variable | Excel Programming |