ComboBox Value to send text to correct worksheet

  • Hi All,

    Be gentle newbie here! and to VBA


    Im trying to get the combox value to point to a worksheet where the text in the user form can be sent.

    Any help would be greatful



    RowCount = Worksheets("cboxProductType.value").Range("a1").CurrentRegion.Rows.Count

    With Worksheets("cboxProductType.value").Range("a1")

    .Offset(RowCount, 1) = txtProduct.Value

    .Offset(RowCount, 2) = txtDescription.Value

    .Offset(RowCount, 3) = txtPerUnit.Value

    .Offset(RowCount, 6) = txtPrice.Value

    .Offset(RowCount, 7) = cboxSupplier.Value

  • Welcome to the Forum. Please read the Forum Rules to understand how the Forum works and why I have added Code Tags to your post


    All VBA code posted in the forum must be wrapped in code tags, which you omitted, including single-line code snippets.Be sure to use them in future posts.


    How to use code tags

    Note: no apostrophe in the tags, just used for demonstration here.

    ['code]


    your code goes between these tags


    ['/code]


    Or, just highlight all of the code and press the <> in the post menu above button to add the code tags.


    Thanks.


    You might want to provide your solution which might help others or maybe you will get better code offered.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!