Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
My goal is to be able to have my loop go through a list and check if
any cell in column a is equal to the list, if not it must make a prompt for the next 7 cells. If ActiveCell.Value 1 Then 'Not sure how to make this only column 1 For Each ce In Range("L1:L500" & Cells(Rows.Count, 1).End(xlUp).Row) 'Not sure how to use my named range "Material Numbers" instead of "L1:L500" ce.Offset(0, 1) = WorksheetFunction.CountIf(Range("L1:L500"), ce.Value) If ActiveCell.Value = ce.Value Then ActiveCell.Offset(0, 1) = InputBox("Enter data", "Column B") ActiveCell.Offset(0, 2) = InputBox("Enter data", "Column C") ActiveCell.Offset(0, 3) = InputBox("Enter data", "Column D") ActiveCell.Offset(0, 4) = InputBox("Enter data", "Column E") ActiveCell.Offset(0, 5) = InputBox("Enter data", "Column F") ActiveCell.Offset(0, 6) = InputBox("Enter data", "Column G") ActiveCell.Offset(0, 7) = InputBox("Enter data", "Column H") Exit Sub Else Next ce End If Thanks any help is appreciated -Matt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Testing for Cell Validation | Excel Programming | |||
Validation (Drop down list vs simple text length validation) | Excel Programming | |||
Validation (Drop down list vs simple text length validation) | Excel Programming | |||
Validation (Drop down list vs simple text length validation) | Excel Programming |