Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to insert object into spreadsheet ??
Hi, I would like to have a square (ie. three cells long) that contain information that the user must input, and can be moved around th spreadsheet. Can I program this in VBA ? Any help is greatly appreciated. Ale -- klusk ----------------------------------------------------------------------- kluska's Profile: http://www.excelforum.com/member.php...fo&userid=3774 View this thread: http://www.excelforum.com/showthread.php?threadid=57324 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to insert object into spreadsheet ??
Sub AddATextBox()
Dim rng As Range, bx As Shape Set rng = Range("B9:D9") Set bx = ActiveSheet.Shapes.AddTextbox( _ msoTextOrientationHorizontal, _ Top:=rng.Top, _ Left:=rng.Left, _ Width:=rng.Width, _ Height:=0.75 * rng.Width) bx.TextFrame.Characters.Text = "Add some text here" With bx.TextFrame.Characters.Font .Name = "Arial" .FontStyle = "Regular" .Size = 10 .Strikethrough = False .Superscript = False .Subscript = False .OutlineFont = False .Shadow = False .Underline = xlUnderlineStyleNone .ColorIndex = xlAutomatic End With End Sub is a possibility. -- Regards, Tom Ogilvy "kluska" wrote: Hi, I would like to have a square (ie. three cells long) that contains information that the user must input, and can be moved around the spreadsheet. Can I program this in VBA ? Any help is greatly appreciated. Alex -- kluska ------------------------------------------------------------------------ kluska's Profile: http://www.excelforum.com/member.php...o&userid=37740 View this thread: http://www.excelforum.com/showthread...hreadid=573242 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i prepare a macro to insert drawing object on specific cell | Excel Discussion (Misc queries) | |||
Macro to insert an object in a specific cell 2007` | Excel Discussion (Misc queries) | |||
Macro to insert a object in excel | Excel Discussion (Misc queries) | |||
How do I insert a 2-3 page Excel spreadsheet as an object in MS Wo | Excel Discussion (Misc queries) | |||
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) |