Closed Thread
Results 1 to 10 of 10

UserForm TextBox and ComboBox selections populate SPECIFIC spreadsheet cells

  1. #1
    ZIXILPLIX
    Guest

    UserForm TextBox and ComboBox selections populate SPECIFIC spreadsheet cells

    Please open the attached spreadsheet, click the "Show UserForm" button to get a feel for what I am trying to accomplish, click cancel on the UserForm, then press Alt+F11. Double-click on UserForm1 then press F7. This will show the UserForm code with all the detailed instructions, but the down and dirty is this:

    I need the UserForm to appear where we have the User hand-jam a few number entries, and make a few selections from dropdowns. Then the User clicks the "Add Information" CommandButton and the typed/selected data from the UserForm is pasted into the spread sheet in the desired specific locations.

    Any help would be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: UserForm TextBox and ComboBox selections populate SPECIFIC spreadsheet cells

    Basically, you want the whole lot coding!
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    ZIXILPLIX
    Guest

    Re: UserForm TextBox and ComboBox selections populate SPECIFIC spreadsheet cells

    Yes, but I was just trying to save from having to make multiple posts for realated questons. TextBox 1 and 3 will be identical except for the destination. Same with TextBox 2 and 4 and ComboBox 1 and 2. I think the only thing that would pose someone with experience a challage is the code for CommandButton1. And I figure some ppl would help me by solving only parts they know how to and leave other parts to be solved by others with more knowledge/experience. That's how I've been helped in the past. I'm tyring to reduce my problem to bite-sized chunks.

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: UserForm TextBox and ComboBox selections populate SPECIFIC spreadsheet cells

    You've asked questions about populating a Combobox but not tried to apply it. I don't mind helping,but you should show some effort yourself first

  5. #5
    ZIXILPLIX
    Guest

    Re: UserForm TextBox and ComboBox selections populate SPECIFIC spreadsheet cells

    I've tried several things and none have worked which is why I'm here. I have no background whatsoever in programming. ALL the code I've learned on my own is through recording a macro and then viewing the code to see why it did what it did. So when it gets into something more complicated then cell reference or a simple formula, it starts to go beyond my knowledge set. I am trying to solve a specific problem and learn along the way which is what this site is for, isn't it? I'm not interested in proving to you that I've worked hard enough to earn your help. So unless you're posting something that is specifically going to go towards answering my questions, you can just stay on your high horse and keep riding. And you can save the part about your "administrative responsibilities" which I am sure is the forthcoming response. I have been working litterally months on this project and the VAST majority of it I figured out on my own. I didn't even know about this website until I ran into something I was totally lost on and did a google search. So please don't waste your energy or my time if you're not interested in helping.

  6. #6
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: UserForm TextBox and ComboBox selections populate SPECIFIC spreadsheet cells

    If you want free help find & pay for a consultant. Also,find another help source
    Last edited by royUK; 05-05-2010 at 03:05 PM.

  7. #7
    ZIXILPLIX2
    Guest

    Re: UserForm TextBox and ComboBox selections populate SPECIFIC spreadsheet cells

    If I pay for a consultant, how is that free help? You don't make a whole lot of sense. Therefore I will ignore you now, but I will leave you with this: this website IS free help. Did you notice when you registered, that you didn't pay for the logon? How could you possibly miss that fact? OMG! Did someone convince you to pay for this site? Dude, you can stop paying your monthly dues now, this site is free. It's funny that someone scammed you but ima hook a brother up. Now please start making sense and think about what you write BEFORE you write it. I don't know who you think you are, but who ever it is, you're wrong. heh heh

    P.S. I like this source. I think I'll stay.
    Last edited by ZIXILPLIX2; 05-23-2010 at 12:34 AM.

  8. #8
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: UserForm TextBox and ComboBox selections populate SPECIFIC spreadsheet cells

    We have rules, one of which involves politeness to all members. Cretins like you don't understand & don't deserve free help.

  9. #9
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: UserForm TextBox and ComboBox selections populate SPECIFIC spreadsheet cells

    Good on RoyUK for banning you twice!!

    I've tried several things and none have worked which is why I'm here. I have no background whatsoever in programming.
    Fine. But if you're after a code solution, we'd expect you to want to learn.

    ALL the code I've learned on my own is through recording a macro and then viewing the code to see why it did what it did.
    Good start! Next steps would be to get a VBA book and learn what the recorded code actually does and how to improve it.

    So when it gets into something more complicated then [sic!] cell reference or a simple formula, it starts to go beyond my knowledge set.
    Challenge yourself. Nobody was born with VBA knowledge.

    I am trying to solve a specific problem and learn along the way which is what this site is for, isn't it?
    This site is about helping people who can state what their problem is and get them along on their learning curve. It's not a ticket to the gravy train.

    I'm not interested in proving to you that I've worked hard enough to earn your help.
    We're not interested in how hard you work. We're only interested in seeing that our voluntary contributions, delivered in our own, free time, without any pay or other recognition, get some kind of acknowledgement from the asker.

    So unless you're posting something that is specifically going to go towards answering my questions, you can just stay on your high horse and keep riding.
    Now, here is where it gets interesting. It sounds as if you have a right to receive answers here. Can you detail how you came into that right? Because we're all volunteers here. I'd like to see the SLA that seems to guarantee you a solution.

    And you can save the part about your "administrative responsibilities" which I am sure is the forthcoming response.
    Chap, you want help. You've happened to find a moderated forum, where rules exist and are actually enforced. You don't like it - leave.

    I have been working litterally [sic!] months on this project and the VAST majority of it I figured out on my own.
    Congratulations. Keep at it!

    I didn't even know about this website until I ran into something I was totally lost on and did a google search.



    So please don't waste your energy or my time if you're not interested in helping.
    Wrong attitude. Don't waste our time or energy if you are not prepared to take what this forum is prepared to give.

    This is not a free full-service coding-to-your-specs site. You need to do the leg work. Try rent-a-coder instead. If you have a question about a specific challenge, ask, and whoever feels they have a suggestion, will post an answer. No warranties, no time frames, no deadlines.

    If you require a full-service solution to your problem, without putting in any effort yourself, engage a paid consultant.

    On this site, we are all volunteers. We post here because we like to help people. You do not have any claim to our contributions, time, or advice.

    cheers

  10. #10
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: UserForm TextBox and ComboBox selections populate SPECIFIC spreadsheet cells

    Wellput Teylyn.

    He/she has been banned twice,but be prepared for rude PMs & negative feed back with rude comments.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1