Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Daya100

  1. Daya100

    going from form to form

    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...
  2. Daya100

    repeating

    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...
  3. Daya100

    repeating

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

    repeating

    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...
  5. Daya100

    excel get cell value

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

    excel get cell value

    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
  7. Daya100

    excel get cell value

    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...
  8. Daya100

    excel get cell 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...
  9. Daya100

    list cells in list box

    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...
  10. Daya100

    list cells in list box

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

    list cells in list box

    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
  12. Daya100

    list cells in list box

    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.
  13. Daya100

    list cells in list box

    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...
  14. Daya100

    list cells in list box

    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!!!
  15. Daya100

    list cells in list box

    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...
See more

Part and Inventory Search

Back
Top