Struggling with this one. In-line Cell formatting again

NoSparks · #7 02-16-2017, 09:26 AM

That's interesting...

What shows at the bottom of the drop down isn't blank,
what shows in the formula bar is the single quote
doing a len() calculation of the cell gives zero
and running this little code I use to see what's actually in a cell returns nothing

Code:

Sub CheckOfCharacters()
    Dim i As Integer
    Dim str As String

str = ActiveCell.Value

    For i = 1 To Len(str)
        Debug.Print Mid(str, i, 1) & "  =  " & Asc(Mid(str, i, 1))
    Next

End Sub

I guess the work around would be to put your list into a column somewhere and in the validation for the list specify the range plus the cell on the next row which would be empty.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formatting unprotected cell in protected w/s makes the cell locked?	tango356	Excel	2	01-23-2017 02:13 PM
Pasting text from Excel cell into word without creating a table, and keeping the in-cell formatting	hanvyj	Excel Programming	0	08-28-2015 01:15 AM
Question re: Conditional formatting (cell occurs after another cell)	Saywarder	Excel	1	04-20-2015 11:29 AM
Conditional Cell Formatting: Alternating Cell Checks	corbott	Excel	4	12-16-2014 01:51 PM
How can I fill cell color starting from Cell D5 using Conditional formatting instead	Learner7	Excel	0	07-08-2010 05:50 AM