vba - recording a value from cell when selecting an option from a listbox in excel -
vba - recording a value from cell when selecting an option from a listbox in excel -
i working excel document, have listbox in 1 cell. when select 1 alternative listbox, there cell computes value. want save value in cell. there way can done without typing manually?
i'm not sure totally follow. it?
you have dropdown menu, assigned particular cell command (let's a1). cell stores integer, index of item of list have selected. based on value, want compute value , set in cell. lost there.
excel vba listbox
Comments
Post a Comment