| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically input a symbol in a selected cell
I have a range of cells that when a cell is selected can a symbol be input in
that cell? and if selected again remove the symbol. Can this bee done? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatically input a symbol in a selected cell
Is this so you can see the selected cell better?
If yes, you may want to look at Chip Pearson's utility: http://www.cpearson.com/excel/RowLiner.htm Different, but similar. mapesii wrote: I have a range of cells that when a cell is selected can a symbol be input in that cell? and if selected again remove the symbol. Can this bee done? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatically input a symbol in a selected cell
Try something like this
It goes into the worksheet module, when you right click on the range A1:A10 a check mark will appear or be removed from the selected cell. Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean) If Not Intersect(Target, Range("A1:A10")) Is Nothing Then Cancel = True If Target < "a" Then With Target.Font .Name = "Webdings" End With Target.FormulaR1C1 = "a" Else: Target = "" End If End If End Sub |
|
#4
|
|||
|
|||
|
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 2 And Target.Column = 2 Then
Sheet1.Cells(Target.Row, Target.Column).Value = "©"
End If
End Sub
Chris ------ Convert your Excel spreadsheet into an online calculator. http://www.spreadsheetconverter.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update Worksheet Name Base on Cell Input Automatically? | Excel Discussion (Misc queries) | |||
| cell automatically deletes content if cell is selected | Excel Discussion (Misc queries) | |||
| Code to Query SQL Server with a parameter value (entered into an Input Box), and have that value also display in a selected cell on a worksheet | Excel Discussion (Misc queries) | |||
| Code to Query SQL Server with a parameter value (entered into an Input Box), and have that value also display in a selected cell on a worksheet | Excel Worksheet Functions | |||
| Change Currency symbol dependant upon selected cell value | Excel Discussion (Misc queries) | |||
Linear Mode
