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:
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,022
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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,167,834
Messages
5,855,898
Members
431,772
Latest member
dannyboi1

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