Macro Validation

[Chris Davison]

On 2002-05-26 08:25, wren17 wrote:
I am new to the VBA world and i need a
little help on writing a Validation Macro.

I have gotten this far:


Range("B17").Select
With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="=$B$111:$B$225"
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.ShowInput = True
.ShowError = True
End With

However, when this is ran The cell (B17) will show the data in Cell (B111), which is the first cell in my validation list. I dont want (B111) to show up in (B17). I want to be able to name whatever Cell In my List Range that i want to come up. Like for instance. Cell (B112) to appear in (B17) when the macro executes.

If someone could help me i would really appreciate it. The book i have is a little too basic and does not cover validations. I have gotten this far with the Excel Help only.

Matthew Bertrand

[Ivan F Moala]

Hi Mathew
I'm a little lost as to exactly what you want
To get what ever you want to appear in your
cell validation just set it to a valid validation within your validation range.
eg. Last line of your code just put in:

Range("B17")=Range("B112")



OR



[B17] = Range("B111:B225").Item(3)  'Where 3 is the 3rd item in the list

Is this what you are after ??

[wren17]

It sure is.

Thanks Alot

I will try that.

Matthew Bertrand