+ Reply to Thread
Results 1 to 2 of 2

User form to paste options to multiple cells

  1. #1
    Registered User
    Join Date
    05-09-2010
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    41

    User form to paste options to multiple cells

    I have a userform that automatically opens by running another macro. I need it to allow a user to select a method. The form has 3 OptionButtons, True, False and NA. Based on which OptionButton the user selects, a value is placed in several cells. So if the radio button next to True is selected, then the number 100 is placed in cells C10, C20, C30, C40 and C50 when a command button is clicked. If the False radio button is selected, then the number 50 is placed in those same cells and if NA is selected then "NA" is placed in cells C10, 20, 30, 40 & 50. I have the userform built, but I can't seem to get it to do what I need it to. Any help would be greatly appreciated. Attachment 134376

  2. #2
    Registered User
    Join Date
    05-09-2010
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    41

    Re: User form to paste options to multiple cells

    Ok, I've realized part of my problem which is most likely going to complicate the solution, but the situation is this... I have an excel file (called "orig" for the sake of this question) that once you open it, it immediately takes you to File Open window. You then browse to a .csv file that you saved earlier and click on it and the macros start crunching numbers. Here's where I'm running into issues. The UserForm is in the "orig" file and it seems that when the UserForm1.Show bit of code tries to execute, it's not finding the UserForm. Do I somehow need to tell it that the form is in the "orig" file? Like orig.workbook.UserForm1.Show or something like that? Thanks!

+ Reply to 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