Set cell value!

  • Thread starter Thread starter Kim-Anh Tran
  • Start date Start date
K

Kim-Anh Tran

I would like to set cell A1 to accept only "A" value.
I appreciate any help!
Thanks in advance!
Kim-An
 
Hi Kim-Anh

A way you could Achieve what you want is to use something like this


Code
-------------------

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 1 And Target.Column = 1 Then
Select Case Target.Formula
Case "A"
'allow this
Case ""
'allow this
Case Else
'reset to nothing
Target.Formula = ""
End Select
End If
End Sub

-------------------


this validates the value of A1 after the user leaves the cell.

HTH

Davi
 
You must log in or register to reply here.

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

Set value of a cell with a dropdown list during run time (C#) 10
VBA set thick borders around non empty cells in range 0
Create Workbooks and then create Worksheets within them 2
A data validation question 1
Excel Need Countifs Formula Help 0
Display entire number in cell 3
How to assign unit for TimeValue? 20
Excel VBA 1

Back
Top