Search:

Type: Posts; User: My Aswer Is This; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.40 seconds.

  1. Re: Conversion of column list to comma delimited string

    So in this example you have:

    A1 USA
    A2 Germany

    Etc.

    So where do you want the results entered?
  2. Re: Running multiple macros with one command button on userform

    Assuming all your scripts work OK when the buttons are pressed separately then I'm not sure what the problem might be.

    You are using select a lot.

    Try using a script like this:
    You will see I...
  3. Re: Running multiple macros with one command button on userform

    I want to see the code in the Button.

    The button must have some code in it.
  4. Re: Running multiple macros with one command button on userform

    Show us the actual scripts. There may be something wrong with the scripts.
  5. Re: Running multiple macros with one command button on userform

    All those Private Sheet scripts change them to Public like this:

    Public Sub CommandButton1_Click()
    MsgBox "Hello"
    End Sub
  6. Re: Change Sheet Tab color based on date in cell of different Sheet

    Try this:
    This is an auto sheet event script
    Your Workbook must be Macro enabled
    To install this code:
    Right-click on the Master sheet tab
    Select View Code from the pop-up context menu
    Paste...
  7. Re: Populate textbox dependent on combobox value

    You would need to put this code in all 4 ComboBoxes

    The script searches Sheet(2).Table named "foundation" Column(1) and adds the value in column(2) of the Table into TextBox1 on sheet1

    ...
  8. Re: Populate textbox dependent on combobox value

    I would like for you to give me a couple examples.


    So if in Combobox you select Red

    You said:

    So what I need to happen is when I select a colour in combobox1 it will search for that colour...
  9. Re: Code link optionbutton ,compobox with textbox and cells in sheet

    I have no other solution for you.
    Maybe someone else here on the forum will have another solution.
    You did not say what it did.
  10. Re: Populate textbox dependent on combobox value

    So if the colors are in a Table why do you need the comboboxes?

    You said:


    This table has the twelve colours in column A

    I have four comboboxes with twelve colours on the list (each has an...
  11. Re: Code link optionbutton ,compobox with textbox and cells in sheet

    I thought you wanted the script to run when you choose the item in the ComboBox

    So choose the value in the ComboBox and then click the option Button.

    Put these two scripts in the proper Option...
  12. Re: Populate textbox dependent on combobox value

    We always need specific details.
    Like you said:



    i want the textbox to populate with information which corresponds to the Value "Red"; this information is on sheet 2.


    You did not say...
  13. Re: Code link optionbutton ,compobox with textbox and cells in sheet

    Try this:
    Put this script in ComboBox1

    Private Sub ComboBox1_Change()
    'Modified 9/19/2019 12:22:01 PM EDT
    Dim ans As String
    Dim SearchString As String
    Dim SearchRange As Range...
  14. Re: Combining cells from multiple worksheets into rows on single worksheet

    That is what I thought till he said:

    I need to copy are all over the shop. A1, B23, B12......
  15. Re: Combining cells from multiple worksheets into rows on single worksheet

    In your original post you said


    A1 - First Name
    B1 - Last Name
    C1 - Phone Number


    I thought you meant copy these three ranges from each sheet into sheet named Collated.
  16. Re: Combining cells from multiple worksheets into rows on single worksheet

    I'm assuming this is a mistake.
    You said:

    I am trying to write a macro that copies all of the data from several cells in each
    workbook into a single

    workbook
  17. Re: why it will error when i click my assigned macro to initialize userform ??

    I have no answer. The script you provided should work if you have 7 Multipages.
  18. Re: why it will error when i click my assigned macro to initialize userform ??

    I have b een using Excel for years and never needed more then One Multipage

    A Multipage is like a Workbook.
    And your Multipage can have several Multipage pages

    Just like a Workbook can have...
  19. Re: why it will error when i click my assigned macro to initialize userform ??

    So your saying you have 7 Multipages ?

    I think you may have 1 Multipage with 7 Pages.
  20. Re: how to transfer datas in sheet to my radio button userform ??

    Maybe someone else on the forum will be willing to open your file and help you. I never open files posted here.
  21. Re: how to transfer datas in sheet to my radio button userform ??

    You would need to put Apeyes and Apeno in a Frame
    And Put the other two in a separate Frame

    So you would have two different Frames
    Your script could look like this:

    Private Sub...
  22. Re: how to transfer datas in sheet to my radio button userform ??

    Not sure I see a question here.
    You do not nee to use:


    .Offset(0, 0)

    Your offsetting by nothing.

    And only one Option Button on a UserForm can be set to true.
    Unless you put the option...
  23. Re: Naming Range for Combobox specifically

    Change it to this:

    ComboBox1.RowSource = ""
    ComboBox1.List = Application.Transpose(Range("B1:R1").Value)
  24. Re: Naming Range for Combobox specifically

    Edit
  25. Re: Naming Range for Combobox specifically

    Are both of these Multicolumn ComboBoxes?
    And what type ComboBox
    Form
    Activex

    Or Userform
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4