Buttons for ", & ?

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

I was wondering if there is a way to create macros to enter quote marks
and the ampersand? Similar to the built in buttons for + and = you can
put on the toolbar by customizing?

I like to use the buttons to build formulas.

Thanks
 
hi,
assign these macros to custom icons from the customize box...tools>customize.
click the command tab. on the left scroll down and click macros. drag the
smiley face to the tool bar. click modify selection>assign macro. you might
also want to click modify selection>edit button image.
Sub Macro1()
ActiveCell.FormulaR1C1 = """"
End Sub
Sub Macro2()
ActiveCell.FormulaR1C1 = "&"
End Sub
regards
FSt1
 
hi again,
I stumbled on to your post in programing and now understand more of what you
are trying to do. the procedures i posted to you wont work during edit mode.
sorry.
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to access macros via tool buttons? 2
How to remove customized button from toolbar? 1
Excel 2003 - assign macro to custom toolbar button 1
Access Automatically Send a notification email once a record is added 0
Excel Footer Dilemma 1
Make custom buttons point to local macros always 2
How to assign macro coding into customized button? 4
Excel 2007 -- Assign a macro to a button 1

Back
Top