Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
trouble finding object to use
Which object controls the ability to type in either the formula bar or
directly in a cell? Specifically, how can I get the text selection so I can superscript or subscript it? As an example, instead of H2O, I would like the 2 to be subscripted. I know how to do this via format cells, but I would like to do it in code so I can assign a toolbar button to it. wazooli |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
trouble finding object to use
Macros don't run when you are in Edit mode. At least not in anyway that they can be used to subscript the current character you are entering. Whether you can enter a formula directly in a cell is controlled in Tools=Options=Edit tab. -- Regards, Tom Ogilvy "Wazooli" wrote in message ... Which object controls the ability to type in either the formula bar or directly in a cell? Specifically, how can I get the text selection so I can superscript or subscript it? As an example, instead of H2O, I would like the 2 to be subscripted. I know how to do this via format cells, but I would like to do it in code so I can assign a toolbar button to it. wazooli |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
trouble finding object to use
Right, I got all of that. Basically, lets say I am typing along, and as part
of what I am typing, the characters I enter are "dH2O". I want a sub that will find the string "dH2O", and subscript the 2. If this could happen while I was typing, all the better. I realize that all I would really have to do is go back over the 2 after I have finished typing, go to 'format cells...', and change the selected text to subscript, but hey - it's a learning process for me, and a matter of curiousity to see how it's done. wazooli "Tom Ogilvy" wrote: Macros don't run when you are in Edit mode. At least not in anyway that they can be used to subscript the current character you are entering. Whether you can enter a formula directly in a cell is controlled in Tools=Options=Edit tab. -- Regards, Tom Ogilvy "Wazooli" wrote in message ... Which object controls the ability to type in either the formula bar or directly in a cell? Specifically, how can I get the text selection so I can superscript or subscript it? As an example, instead of H2O, I would like the 2 to be subscripted. I know how to do this via format cells, but I would like to do it in code so I can assign a toolbar button to it. wazooli |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
trouble finding object to use
Actually, maybe I'm being to difficult about this. What I really want is to
replicate the subscript button from Word. That way, I can subscript whatever text might be selected in the cell. Does that make it clearer? "Tom Ogilvy" wrote: Macros don't run when you are in Edit mode. At least not in anyway that they can be used to subscript the current character you are entering. Whether you can enter a formula directly in a cell is controlled in Tools=Options=Edit tab. -- Regards, Tom Ogilvy "Wazooli" wrote in message ... Which object controls the ability to type in either the formula bar or directly in a cell? Specifically, how can I get the text selection so I can superscript or subscript it? As an example, instead of H2O, I would like the 2 to be subscripted. I know how to do this via format cells, but I would like to do it in code so I can assign a toolbar button to it. wazooli |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
trouble finding object to use
You do rich text formatting with the Characters object.
You can turn on the macro recorder and then do it manually. This will give you the basic code you need. -- Regards, Tom Ogilvy "Wazooli" wrote in message ... Actually, maybe I'm being to difficult about this. What I really want is to replicate the subscript button from Word. That way, I can subscript whatever text might be selected in the cell. Does that make it clearer? "Tom Ogilvy" wrote: Macros don't run when you are in Edit mode. At least not in anyway that they can be used to subscript the current character you are entering. Whether you can enter a formula directly in a cell is controlled in Tools=Options=Edit tab. -- Regards, Tom Ogilvy "Wazooli" wrote in message ... Which object controls the ability to type in either the formula bar or directly in a cell? Specifically, how can I get the text selection so I can superscript or subscript it? As an example, instead of H2O, I would like the 2 to be subscripted. I know how to do this via format cells, but I would like to do it in code so I can assign a toolbar button to it. wazooli |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trouble Finding Duplicate Values with Conditional Formatting | Excel Discussion (Misc queries) | |||
Having trouble finding the right function | New Users to Excel | |||
I'm having trouble finding my posted questions? | Excel Discussion (Misc queries) | |||
trouble returning a workbook level Name object | Excel Programming | |||
Macro trouble finding 'empty' cells | Excel Programming |