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.