Thanks Thanks:  0
Likes Likes:  0
Page 2 of 4 FirstFirst 1234 LastLast
Results 11 to 20 of 34

Thread: VBA form question

  1. #11
    New Member
    Join Date
    Jan 2019
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA form question

    I will do this later today. The holiday has me busy. This is looking very promising! I cannot thank you enough for taking time on a weekend to help me.

  2. #12
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    3,264
    Post Thanks / Like
    Mentioned
    26 Post(s)
    Tagged
    9 Thread(s)

    Default Re: VBA form question

    Do not worry, it's just an advance. Enjoy your holidays.
    Regards Dante Amor

  3. #13
    New Member
    Join Date
    Jan 2019
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA form question

    I just inserted the code and it looks great! I have 2 comments

    I noticed the Page Rate choices in the form do not reflect accurate numbers after 4.4

    The date submitted field in the form should not be required to add the record as this is usually entered after the "job" has been added. That is my error for not clarifying.

    Best regards

  4. #14
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    3,264
    Post Thanks / Like
    Mentioned
    26 Post(s)
    Tagged
    9 Thread(s)

    Default Re: VBA form question

    Quote Originally Posted by dosman View Post
    I just inserted the code and it looks great! I have 2 comments

    I noticed the Page Rate choices in the form do not reflect accurate numbers after 4.4

    The date submitted field in the form should not be required to add the record as this is usually entered after the "job" has been added. That is my error for not clarifying.

    Best regards

    Where do not they reflect exact numbers, in the textbox on the sheet?

    And Only remove the validation:


    Code:
        If TextBox2.Value = "" Or Not IsDate (TextBox2) Then
            MsgBox "Enter a date", vbExclamation
            TextBox2.SetFocus
            Exit Sub
        End If
    Regards Dante Amor

  5. #15
    New Member
    Join Date
    Jan 2019
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA form question

    My apologies for the late reply. It was in the drop down list on the form where I choose the page rate. if you look at the page rate validation I should be able to choose from 3.25 up to 5.00 in increments of .25. In the form it stops at 4.4 and starts adding long decimal numbers. I will fix the validation with the code you sent. Thank you!

  6. #16
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    3,264
    Post Thanks / Like
    Mentioned
    26 Post(s)
    Tagged
    9 Thread(s)

    Default Re: VBA form question

    You're welcome.
    Regards Dante Amor

  7. #17
    New Member
    Join Date
    Jan 2019
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA form question

    Quote Originally Posted by dosman View Post
    My apologies for the late reply. It was in the drop down list on the form where I choose the page rate. if you look at the page rate validation I should be able to choose from 3.25 up to 5.00 in increments of .25. In the form it stops at 4.4 and starts adding long decimal numbers. I will fix the validation with the code you sent. Thank you!

    Did you see what I was referring to? Since this is in development I know it's probably an easy fix. Thanks again

  8. #18
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    3,264
    Post Thanks / Like
    Mentioned
    26 Post(s)
    Tagged
    9 Thread(s)

    Default Re: VBA form question

    I will fix the validation with the code you sent.
    I assumed you were going to fix it
    Regards Dante Amor

  9. #19
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    3,264
    Post Thanks / Like
    Mentioned
    26 Post(s)
    Tagged
    9 Thread(s)

    Default Re: VBA form question

    Enter the excel options and activate: Precision as displayed

    Regards Dante Amor

  10. #20
    New Member
    Join Date
    Jan 2019
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA form question

    I apologize for getting back to you do late. I really think the form is going to work as you submitted in the advance unless you think it is not. My only question is how to invoke the form from the main sheet with a button. I do not see any modules to call.

    Thanks again for your assistance

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •