Search:

Type: Posts; User: vanoskyj; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    1
    Views
    442

    i have 151 rows of data in my excel spreedsheet. ...

    i have 151 rows of data in my excel spreedsheet. The data gets entered through a Userform1. I want to be able to generate a receipt for the user by using the txtname field. I also would like the...
  2. Replies
    1
    Views
    886

    When the user enters a date in the date field...

    When the user enters a date in the date field (txtbox) the data seems to be going to only one date tab (current month). I need the data to go into the correct month tab. another words if the data...
  3. Replies
    1
    Views
    1,840

    is there a way to have the data listed within the...

    is there a way to have the data listed within the spreedsheet go to a ticket or receipt (that looks just like the userform) in case the user needs to print it out?
  4. don't know why I didn't think of that.... ...

    don't know why I didn't think of that.... thanks buddy.
  5. i have a user form (vba) that inputs data into...

    i have a user form (vba) that inputs data into the spreedsheet. but when i exit out of the userform and go into the spreedsheet there is no way for me to bring back up the userform. I have to close...
  6. Replies
    14
    Views
    3,339

    i have a user form (vba) that inputs data into...

    i have a user form (vba) that inputs data into the spreedsheet. but when i exit out of the userform and go into the spreedsheet there is no way for me to bring back up the userform. I have to close...
  7. Replies
    7
    Views
    2,338

    thank you again for your time and knowledge. As...

    thank you again for your time and knowledge. As you can tell I'm not that good. Heck I just dabble in it. So any and all help is appreciated.
  8. Replies
    7
    Views
    2,338

    ok guy he it all is gentleman all of it in it's...

    ok guy he it all is gentleman all of it in it's entirety. If you see anything that you think you can achieve better please by all means alter the code and let me know. Because time is running out...
  9. yes , but I thought you had to list each problem...

    yes , but I thought you had to list each problem seperatley

    can you assist on my last problem please, i get that done and thats it for me for a while.

    I have drawn an example of my problem. ...
  10. Replies
    7
    Views
    2,338

    sure but wouldn't I have to do that for every row...

    sure but wouldn't I have to do that for every row in the spreadsheet?

    I tried this code below too but it still puts in tru or false



    Private Sub cmdenter_click()
    If checkbox1 Then
    ...
  11. Replies
    7
    Views
    2,338

    i'm using a user form that has a checkbox, when i...

    i'm using a user form that has a checkbox, when i check the checkbox the result in my spreadsheet is either true or false, but i need it to be yes or no.

    i have tried numerous codes that are out...
  12. I have a checkbox that either puts the output...

    I have a checkbox that either puts the output (spreedsheet) as true or false but what I need it to put in the spreedsheet column g (each entry will use a different row) is either the word pickup or...
  13. Replies
    3
    Views
    657

    the data entry operator is fast so she would like...

    the data entry operator is fast so she would like to just skip the empty text boxes (thats what the quantity parts and amount are.
    so if there is quantity = 1 part = tire amount = 5 cents and...
  14. Replies
    3
    Views
    657

    I have 8 different items ... ...

    I have 8 different items ...

    quantity----------parts------------amount
    quantity----------parts------------amount
    quantity----------parts------------amount...
  15. Thread: option boxs

    by vanoskyj
    Replies
    1
    Views
    597

    I have 5 options that the user can chose from on...

    I have 5 options that the user can chose from on the user form.

    a
    b
    c
    d
    e

    I am using option buttons for each one, how would I code it so that when the user
    choses one or all that they...
  16. Replies
    1
    Views
    680

    My data does not get applied to my spreadsheets...

    My data does not get applied to my spreadsheets when I click the cmdbutton - Can anybody help please. I have uploaded a copy of my file. thank you
  17. Replies
    3
    Views
    1,457

    yes sir, I would like for it to show the first...

    yes sir, I would like for it to show the first match then tell me how many are within that certain spreadsheet. My spreadsheets are named after the date MMMYYYY (Jul2010) etc...

    P.s.

    I'm sorry...
  18. Replies
    56
    Views
    1,826

    Re: hyperlink parents. (excel 2000)

    ok one last word on this subject.

    Is there any way That I can make it go faster because the wait is at least 4 minutes if there is more than 10 child/parents it has to find.?

    And now that I...
  19. Replies
    56
    Views
    1,826

    Re: hyperlink parents. (excel 2000)

    ok, I finally have it working where it finds everything needed except. If the cell conatins PSA-100 it finds everything that mayches it exactly. What about wildcards. How can I not only find the...
  20. Replies
    56
    Views
    1,826

    Re: hyperlink parents. (excel 2000)

    Point well taken!!! My apolgies, I'm just frustrated thats all.
  21. Replies
    56
    Views
    1,826

    Re: hyperlink parents. (excel 2000)

    I told you guys this was tough. It seems that you all gave up on me.
  22. Replies
    56
    Views
    1,826

    Re: hyperlink parents. (excel 2000)

    Also I have reviewed the Intersect on vba help. dont really understand how that would help. what can I say I'm an Idiot.

    Returns a Range object that represents the rectangular intersection of two...
  23. Replies
    56
    Views
    1,826

    Re: hyperlink parents. (excel 2000)

    I told you I was a newbie..... I really suck at this thats why I'm going to school for it to hopefully get better. I really do appreciate you patience as well as your knowledge. thank you.


    1)....
  24. Replies
    56
    Views
    1,826

    Re: hyperlink parents. (excel 2000)

    Sorry Steve, I was trying some things out of the book.

    I have repaired it. This is what I have so Far.

    Private Sub CommandButton1_Click()
    With Sheet1
    ActiveWorkbook.RefreshAll
    End With...
  25. Replies
    56
    Views
    1,826

    Re: hyperlink parents. (excel 2000)

    i'm sorry to say this but i must leave for school now see you all later I will as always check for any updates. see you all tommorrow my friends
Results 1 to 25 of 129
Page 1 of 6 1 2 3 4