Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macros to create symbols
I have a set of symbols to use in flow charts. Instead of clicking on the
drawing tool bar to create the symbols, I am trying to write some macros in such a way that I will have buttons which I will just press and the symbols will be created according to the respectively button that I will press. Example pressing button A creates symbol A |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macros to create symbols
something like:
Sub AddRectangle() With Selection ActiveSheet.Shapes.AddShape msoShapeRectangle, .Left, .Top, .Width, ..Height End With End Sub one for each shape, then link them to the buttons. "kramlys" wrote in message ... I have a set of symbols to use in flow charts. Instead of clicking on the drawing tool bar to create the symbols, I am trying to write some macros in such a way that I will have buttons which I will just press and the symbols will be created according to the respectively button that I will press. Example pressing button A creates symbol A |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
macros to create symbols
The one line macro below add a rectangle to the worksheet. the rectangle is a
standard shape. yo could do the same with clip art or a custom symbol that you create. If you are looking to add a character sysmbol then use this code. To run the macro you have to get out of the text entry mode (typing characters into a cell) to run the button. I'm adding the degree sign. Private Sub CommandButton2_Click() ActiveCell.Value = ActiveCell.Value & "°" End Sub "kramlys" wrote: I have a set of symbols to use in flow charts. Instead of clicking on the drawing tool bar to create the symbols, I am trying to write some macros in such a way that I will have buttons which I will just press and the symbols will be created according to the respectively button that I will press. Example pressing button A creates symbol A |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Symbols on the keyboard are not the symbols on the screen.... | Excel Discussion (Misc queries) | |||
Can I create a custom symbols library? | Excel Programming | |||
Can I create custom symbols library? | Excel Programming | |||
Macros in Personal.xls that would create two toolbars and buttonswith assigned macros | Excel Programming | |||
Automatically create trend table using symbols | Charts and Charting in Excel |