Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying text from regular textbox
I'm trying in VBA to copy the text from a textbox. When I try recording the macro of what I'm doing it uses the specific text in the box, but since I want to copy the users text this will not work: ActiveSheet.Shapes("Text Box 3").Select Selection.Characters.Text = "Text here" With Selection.Characters(Start:=1, Length:=10).Font ..Name = "Verdana" ..FontStyle = "Regular" ..Size = 10 ..Strikethrough = False ..Superscript = False ..Subscript = False ..OutlineFont = False ..Shadow = False ..Underline = xlUnderlineStyleNone ..ColorIndex = xlAutomatic End With Selection.Copy Range("E21").Select ActiveSheet.Paste any help? Greiffenberg -- Greiffenberg ------------------------------------------------------------------------ Greiffenberg's Profile: http://www.excelforum.com/member.php...o&userid=25311 View this thread: http://www.excelforum.com/showthread...hreadid=388003 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How copy a cell with mixed text (regular, bold, italic) with a fo. | Excel Discussion (Misc queries) | |||
ALL CAPS to regular text? | Excel Worksheet Functions | |||
textbox value copying | Excel Programming | |||
Copying Text from TextBox into cells in table and then addign a new row | Excel Programming | |||
Copying TEXT from Textbox to other location | Excel Programming |