Thread: Case Select
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NoodNutt NoodNutt is offline
external usenet poster
 
Posts: 221
Default Case Select

Bob

Just a couple of follow up questions if I may.

1. the date format in your response, is it

(yyyy,mm,dd) or (yyyy,dd,mm)

2. with the 'Do Something

What would be the best way to set the focus of then Target.Value Cell +1
Cell to the right.

By that I mean, if the the target cell a1, then I need "response" in b1.

Regards
Mark.