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.


    your code goes between these tags


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


    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!