Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
dialogue box if cells are not filled
Hi
I have a spreadsheet with about 100 entry spots I have macros written to save the data, what I would like is a way to stop the save if not all the data is entered, and come up with a text box warning "Not all Data entered" simple answer? thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
dialogue box if cells are not filled
Maybe you could incorporate something like:
dim myRngToCheck as range with worksheets("sheet999") set myrngtocheck = .range("a1:c3,D9,f14") end with if myrngtocheck.cells.count = application.countif(myrngtocheck) then 'all filled with something! else msgbox "Please fill some cells" exit sub end if BillO wrote: Hi I have a spreadsheet with about 100 entry spots I have macros written to save the data, what I would like is a way to stop the save if not all the data is entered, and come up with a text box warning "Not all Data entered" simple answer? thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reminder that cells are not filled in | Excel Discussion (Misc queries) | |||
Average only if ALL cells filled. | Excel Worksheet Functions | |||
Filled cells dont appear as filled | Excel Discussion (Misc queries) | |||
count filled cells | Excel Programming |