Solved

Excel Help, need TradeMark symbol

Posted on 1999-01-14
9
543 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 70 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
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
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

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

630 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