Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Excel Help, need TradeMark symbol

Posted on 1999-01-14
9
Medium Priority
?
550 Views
Last Modified: 2008-02-26
besides typing "ALT+0153" or whatever the combo is. how can i set a single key or make a macro or something to produce the trademark symbol?

thanks,
  pipe
0
Comment
Question by:pipe
9 Comments
 
LVL 2

Expert Comment

by:bushhead
ID: 1615690
not sure about a single key.. but u can type (tm) to make the trademark sign..

bush
0
 
LVL 10

Expert Comment

by:MasseyM
ID: 1615691
Record a macro that will type the (tm) characters in the cell.  
0
 
LVL 2

Accepted Solution

by:
cartti earned 280 total points
ID: 1615692
Type this macro:

Sub Test()
   SendKeys "™"
End Sub

Then assign this macro to a hotkey. To do this, go to Tools-Macro-Macros...  then select "Test" (name referring to the above macro) then options, and choose the key you want to press along side the Ctrl button to activate the macro.
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
LVL 10

Expert Comment

by:MasseyM
ID: 1615693
Man cartii what is your problem.  READ WHAT I TYPED!
0
 
LVL 2

Expert Comment

by:cartti
ID: 1615694
What are you talking about!

Recording a macro to do that will mean the ™ character appears in the cell you typed it in. I suggested a far more flexible approach.

You did not mention anything about the Sendkeys function and nothing about hotkeys. So what is YOUR problem.
0
 
LVL 2

Expert Comment

by:cartti
ID: 1615695
MasseyM - get my handle right too! Spelt c a r t t i
0
 
LVL 10

Expert Comment

by:MasseyM
ID: 1615696
sorry... wasn't paying attention... my macro is designed to insert the tm whenever the character combo of the macro is pressed :)  I apologize for mispelling your handle.  Have a nice day.
0
 
LVL 2

Expert Comment

by:cartti
ID: 1615697
No worries.
0
 

Author Comment

by:pipe
ID: 1615698
rofl
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft has changed the look and feel of Azure AD and Microsoft account sign-in pages so that you will have a more unified look and feel when moving between the two interfaces.
With its various features, Office 365 can not only help you with your day-to-day business tasks, it can also do wonders for your marketing campaign.
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

926 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question