Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation Question
I am trying to do the following:
(this is a time ticket with time codes and hours) In cell A1 you enter the time code (reg,vac or sic) and then in A2 thru A8 you enter hours worked. If you enter a number in cells A2 thru A8 and have not entered a proper time code, then the "Error Alert" message will pop up prompting for a time code. Is this possible? Thanks in advance Kenny -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 100,000 Newsgroups - 19 Different Servers! =----- |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation Question
Put the following in the worksheet's code module.
Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim str1 As String If Target.Column = 1 And Target.Row 1 And _ Target.Row < 9 And Range("A1") = "" Then str1 = InputBox("Enter a time code (reg, vac or sic).") Range("A1") = str1 End If End Sub HTH, Merjet |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation Question
The following website should help you in setting up the 3rd drop-dow box - where the items are dependant on your selection in your 2n drop-down. http://www.contextures.com/xlDataVal02.html Pau ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation Question | Excel Discussion (Misc queries) | |||
Data Validation Question | Excel Discussion (Misc queries) | |||
Data Validation question | Excel Discussion (Misc queries) | |||
Another Data Validation question | Excel Discussion (Misc queries) | |||
Data validation question | Excel Programming |