Results 1 to 5 of 5
  1. #1
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: VBA / Excel - Initializing UserForm (XL2000 Sr-1 VBA)

    Ricky

    I did answer you in the Excel lounge. Do you still need more help?

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: VBA / Excel - Initializing UserForm (XL2000 Sr-1 VBA)

    I do appreciate your response, however; I do need more help. Though I have a good supply of books and tutorials, most code is still greek to me. I think I'm learning fast but a detailed solution to the specific problem is what I really need. I'm down to the hard stuff now (at least it's difficult for me), I've done most all I can (the easy stuff, that is!) by myself.

    My "real" project is much more extensive and about 40 X the size of the example I've posted. I can tackle the "real" issues I have by utilizing and expanding upon the solution to the "example" problem I've posted. In summary, if someone could provide a line or two of code to handle the example problem, I will take it, shape it and manipulate it and apply it to my real project.
    - Ricky

  3. #3
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    VBA / Excel - Initializing UserForm (XL2000 Sr-1 VBA)

    <P ID="edit" class=small>Edited by gwhitfield on 01-Dec-01 13:32.</P>This post was cross-posted <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=xl&Number=96543&page=&view= &sb=&o=&vc=1>here</A>

    With help from many on this forum, I have almost finished my project - just one more hurdle to jump.

    My example includes a database that is filled by the user via a USERFORM. A date is selected, a few entries are made and the information is stored in a database.

    When the user selects a date for editing and data already exists for that date, then the USERFORM should be populated by those previous entries.

    I don't know how to initialize the values on the USERFORM where a combo / list box is involved??

    Please take a look at the example and any advice would be appreciated.
    Attached Files Attached Files
    - Ricky

  4. #4
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: VBA / Excel - Initializing UserForm (XL2000 Sr-1 VBA)

    Ricky

    I am looking into your project and I want to know:

    1) When you say initialize the values of a combo/list box are you talking about the CBOPdOut1, CBOPdOut2 on Userform Expenditures?

    It would be best to show me what you are trying to do by using the example you sent and telling me the object you are trying to work with. <font color=red> REMEMBER... you are familiar with this project and I am not. So you need to give me <font color=blue> ALL </font color=blue> details as if I know nothing. </font color=red>

    Thanks

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  5. #5
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: VBA / Excel - Initializing UserForm (XL2000 Sr-1 VBA)

    Wassim:

    The assumption you've made is correct. You will notice that if you select a date from the calendar and then click UPDATE to edit that days information, the top two textboxes contain previous data. This allows the user to see the previous entries where there were entries.

    The other entries on the userform are not "simple" textbox entries as the amounts do not post to fixed columns in the database. The column for a paid out amount is determined by the choice in an adjacent combo box.

    What I'm looking for: is a way to return the previous values from the two paidouts (i.e. CBOPDOut1) when the userform is initialized.

    It is vital that the user see previous entries on the userform so editing has meaning!

    What's more... if the userform isn't populated with previous data and is left blank when the user clicks FINISH, then the previous data will be overwritten with blanks - That would be trouble.
    - Ricky

Posting Permissions

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