none
ALLOW FIXED COLUMN RANGE... BUT CHANGE DIFFERENT ROW VALUE RRS feed

  • Question

  • I have a UserForm which I use to update printer items in my inventory.

    My userform allows me to show my selected printer item choice including current number in stock from my worksheet TO USERFORM.

    I need to occasionally change/update the current number in stock to a new value. I.E.

    "Sheet5.Range("c3").Value = AddItemBox.Value" works well for ONLY "C3"

    How may I update any other cell value showing in my specific active cell? (NOTE: ALL MY VALUES ARE CALLED FROM THE COLUMN "C" ; BUT VARIABLE ROWS)


    • Edited by bbthekid Tuesday, July 3, 2018 9:22 PM
    Tuesday, July 3, 2018 9:21 PM