Possible to Run Macro while in Edit Mode???

BuddieB

Board Regular
Joined
Aug 6, 2003
Messages
174
I am wondering if it is possible to run a macro while entering text in a cell.

Specifically I am looking for easy ways to enter superscript, subscript and greek characters into cells.

The cells would be shown as text only (though most likely formatted as general) and would not be part of a formula...

Is this possible? Or am I only dreaming of a perfect XL world? :rolleyes:
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,014
Nope. Can't run a macro whilest in Edit mode. End of story.

You could write a macro that would take entries and alter them after you've entered them allowing you to specify certain preformatting things, similar to what the BB does if you enter a left-bracket "[" a letter and a right-bracket. Example: you input This is [p]superscript[/p] and this is [g]Greek[/g] and your macro then parses and formats the text appropriately.
 

BuddieB

Board Regular
Joined
Aug 6, 2003
Messages
174
Thanks Greg, that is what I feared. I was just hoping that there was a nice way to format similar text similar to the things I can do with Word.

Thanks for your tip on the BB code parameters, but I think that will be longer than the methods I use now to just enter the values and format the characters as I type.

Thanks for your help.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,190
Messages
5,594,761
Members
413,931
Latest member
acrato

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top