Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is it possible to display the number of characters in a cell
I would like to click on a cell and obtain a character count. Is it possible?
|
#2
|
|||
|
|||
Is it possible to display the number of characters in a cell
'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not IsEmpty(Target.Value) Then MsgBox Len(Target.Value) End If End Sub -- HTH RP (remove nothere from the email address if mailing direct) "Paul K." wrote in message ... I would like to click on a cell and obtain a character count. Is it possible? |
#3
|
|||
|
|||
Is it possible to display the number of characters in a cell
Bob:
Thank you for your help, it works great, this is going to be a great time saver today! Paul "Bob Phillips" wrote: 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not IsEmpty(Target.Value) Then MsgBox Len(Target.Value) End If End Sub -- HTH RP (remove nothere from the email address if mailing direct) "Paul K." wrote in message ... I would like to click on a cell and obtain a character count. Is it possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Workaround for Cell Display Limitation in Excel 2000 | Excel Discussion (Misc queries) | |||
fill or truncate to a certain number of characters in a cell | Excel Worksheet Functions | |||
How do you count number of characters in a single cell | Excel Worksheet Functions | |||
How do you count number of characters in a single cell | Excel Worksheet Functions | |||
spread the number 123.45 so each digit goes to a different cell | Excel Worksheet Functions |