ExcelBanter - Pecentage with 7 sale types

how do i do a dropdown box that i can choose 7 different sales types
that all
7 will have a different percentag to calculate, ex if i sell item one
i get
10% commission if i sell item 2 i get 15%...

Option 1) Use the CHOOSE function instead of a dropdown
Option 2) Use Data Validation instead of a dropdown
Option 3) Use the ListFillRange property of a Control Toolbox Listbox
Option 4) Use the Input Range of a Forms Toolbox Listbox

My recommendation is to use the CHOOSE function. It's the easiest and
I strongly believe in the KISS principle.

Keep It Simple, Stupid!

HTH,
Gary Brown

--
Gary L Brown
------------------------------------------------------------------------
Gary L Brown's Profile: http://www.excelforum.com/member.php...o&userid=28563
View this thread: http://www.excelforum.com/showthread...hreadid=484335