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: if cell contains text from list then return value

    This is beyond my knowledgebase.
    I will continue to monitor this thread to see what I can learn.
  2. Re: Creating a group for items in a listbox

    I cannot understand why you think you need two UserForms.

    I'm not really able to help on this question if you for some reason think you need two UserForms.

    I have built hundreds of UserForms...
  3. Replies
    6
    Views
    178

    Re: VBA Find and Select loop

    I provided a code that I thought would work for you and two other posters provided their suggestions on how to do what you wanted.

    But you said nothing about if you tried any of the provided code....
  4. Re: Creating a group for items in a listbox

    The script I just provided was just a sample so you would see how code looks for doing certain things.
    It was not intended for use in the Userform code we are working on.

    So are all your Tables...
  5. Re: Creating a group for items in a listbox

    When dealing with Table we do not need to know where the table starts or ends.

    If I were to write code to find the table all I need to do is write code like this.



    Sub Select_Me()
    'Modified...
  6. Re: if cell contains text from list then return value

    You need the value 1 entered where if the shown values are found where?

    We need specific details to provide you with help.
  7. Replies
    6
    Views
    178

    Re: VBA Find and Select loop

    It's never a good practice to search the entire sheet.
    And it's never a good practice to use active cell.

    I'm not sure I understand your request but if your attempting to search column A for:
    ...
  8. Re: Pls help how to Add multiple rows with same value of combobox through userform

    Assuming you want a Inputbox to ask how many times.
    And assuming you want these values entered into column A

    And assuming you plan to select the values from a list of values in the ComboBox1
    ...
  9. Re: Pls help how to Add multiple rows with same value of combobox through userform

    So you want to always enter the value 5 times?
    If not how do you plan to tell the script how many times?

    And you said:

    excel cells in the column i specify

    How do you plan to specify what...
  10. Replies
    4
    Views
    84

    Re: help code vlookup on userform

    You said:

    it's very simple buddy ??
  11. Replies
    4
    Views
    84

    Re: help code vlookup on userform

    So when you enter a value in TextBox2 you want text to automatically appear in TextBox 1 3 and 4

    So what do you plan to enter in TextBox2

    Will it be the data in sheet1 column 2

    So if you...
  12. Re: VBA goto cell referenced in a cell

    Show me the code your now using.

    I would like to see the code which enters random numbers and also see the code you want to run after the random numbers are entered.
  13. Re: VBA goto cell referenced in a cell

    Please explain in words with specific details what your wanting your script to do.
    And I will see what I can do to help you.

    Normally we should not need to use a Goto
  14. Re: Copy Cell contents to previous row.

    So why not:
    If cell in column E is empty then delete that row.
  15. Re: Creating a group for items in a listbox

    When you ask for help I like a challenge to achieve what users want.

    But I like when I decide a way to achieve the Goal.
    In your previous post you mentioned wanting to use a Table which is a good...
  16. Re: Creating a group for items in a listbox

    The Groups need to be actual Tables.
    And give the Table a name like:

    Cars
    People
    Countries

    A name that identifies what's in the Table

    We need to use a Table so as you later add more...
  17. Replies
    9
    Views
    216

    Re: run time error 1004

    Try this:

    Worksheets("4_Lift Plan").OptionButtons("Option Button 61").Visible = False
  18. Re: Creating a group for items in a listbox

    Well this could be done. Using a table. But each Group would need to be a separate one column Table

    Then we would have to load in the Table names into a listbox on the Userform so then the user...
  19. Re: Creating a group for items in a listbox

    So if you plan to create several Groups how do you plan to keep those Groups groped so the next time you open the Userform the groups are still groped.

    And all these items in the group are in...
  20. Re: Macro to convert 1 row into multiple rows except for zeroes

    So are you saying you want to search columns A B and C of sheet1

    And all the cells in column A that have a number should be entered into Row1 of sheet2

    And all the cells in column B that have a...
  21. Re: Macro to convert 1 row into multiple rows except for zeroes

    I never click on links to Excel files:

    This is way to much code for me to read and understand what your attempting to do.

    Would you please tell me in words what exactly your attempting to do.
    ...
  22. Replies
    4
    Views
    139

    Re: UserForm to replace working code

    Here is a very simple example of how you take values from a Userform Textbox and enter it into a Excel Worksheet Activex Textbox

    Put this script into your Excel Userform Command Button.

    ...
  23. Replies
    4
    Views
    139

    Re: UserForm to replace working code

    If you want show me the code you are now using.
  24. Replies
    4
    Views
    139

    Re: UserForm to replace working code

    I never click on links on this site that take me to a Excel file.

    So you said:

    I have a bid form that works

    A bid form ??

    Do you mean a sheet named bid.
  25. Replies
    8
    Views
    157

    Re: Macro for column of formulas

    Glad we were able to help you.
    Come back here to Mr. Excel next time you need additional assistance.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4