Search results for query: *

I have a database and there are about 10 different forms the user goes through to enter information. Right now I have command buttons on each form that the user clicks on to go to another form - and whatever record they are on in the first form - it finds it on the other form. The code also...

OK - I have this big spreadsheet that people fill out and send to me. Well, they always forget to fill in some cells and the information is required. SO - When they close the workbook I want to run through these 20 cells (on all different sheets in the workbook) and check to make sure they are...

well, they are scattered all over about 10 different sheets. Can I define that as a range?

Hi, I'm trying to repeat the code below for several different cells. Everything stays the same but the cell (range) changes and msg - there are about 20 different ones. I could just keep writing the if statement over and over but I know there is a better way. I was thinking case select...

Hey Skip, Thanks so much! I figured out my error too and I feel like a complete idiot - I had the sheet name wrong.

That's cool. One more question since I'm not so VBA savvy. WHat is Selection? Are you definiing what that is - or it's whatever cells you have selcted currently or...? Thanks

well, what I'm trying to do is see if a cell has a value in it. If it doesn't then I add a tect string to the collection. Then later I add that to a list box. BUT - I'm stuck on getting the cells value. This part: cell = Application.Worksheets("Sheet1").Range("d25").Value...

I tried to get help last week and it didn't quite solve the problem. So - now I have a new approach that doesn't work. I'm trying to add cell values to a collection. But, I keep getting the error that the subscript is out of range. Here is my code: Private Sub UserForm_Activate() Dim...

I feel like the biggest idiot. I still get the refernce error. I have: Private Sub UserForm_Activate() For Each Name1 In ActiveWorkbook.Names Application.Goto Reference:=Name1.Name If IsEmpty(Selection.Value) Then UserForm1.ListBox1.AddItem Name1.Name End If Next End...

More specific - how do I refer to the named range? I have Range("NameofRange") and it doesn't work.

OK - I've put the code in but when the userform activates I get an error that says Name1 is an invalid reference. What did I not do? Thanks! Daya

I don't think I understand your question. I have no idea how to identify the cell in the listbox. I wanted to put something like "First Name" in the list box which is actually cell B5 - but I would put the name so they know what they haven't filled out on the form yet.

OK - I think I know what to do now - just not how. I am trying to evaluate various cells on various different sheets in the workbook (to see if the user filled them out). So, I think I need to create a collection of all of those cells. Then I can use the For...Each...Next statement to see if...

Hey Skip, I'm confused (sorry - I'm new at this). So...am I creating a table with all of the cells that I need to evaluate? And how would I do that? Thanks!!!

I have a userform in Excel that loads on the workbook before save event. I want it to list (in a list box) all of the cells that I have specified that are null or empty. Thanks to Skip I know how to evaluate if a cell is empty. But, there are a good 100 cells that I need to look at - and if...

I'm trying to identify when a cell has not had information entered so that I can give an error. I have tried using IsEmpty and IsNull but nothing seems to work. How do I do this? Thanks! Daya

Hey Skip and Max, Thanks for the replies - very helpful. I have another question though, Skip. How do I add in there that if ValA or ValB are null then I don't want the message box to run. I tried adding if not IsNull ValA and ValA+ValB..... Thanks again!!! Amy

I'm really an access programmer and can't figure out how do do anything in excel. Basically, I want some code that says if A1 + B1 <> C1 then... - I know how to put in the message box. Also, how do I require a field? SO they can't save or move to another sheet if the cell is empty. I...

I'm trying to format a number so that it is 4 characters long. For example 1 would be 0001 and 15 would be 0015. How do I do that? Thanks!

Thanks - now I'm having trouble with the Dlookup. This is what I have: strResult = DLookup(&quot;MktCode&quot;, &quot;MarketIDs&quot;, &quot;GL&quot; = strInput) I'm trying to make the criteria for the &quot;GL&quot; field in the table to be equal to the the result of what the user types in...