Sorry for trouble u all again... (I know I'm quite troublesome...)

My problem is like this:

I got a userform, which consists of a comboBox to let people choos
their name. The row source of the comboBox is refer to sheet2, wher
sheet 2 store the user name, and their hourly payment rate. They got
different hourly payment rate which is $20 and $30 respectively.

I had tried several methods... But I duno how to do so that when the
select the username that time, it will match the username in sheet
and then copy their hourly payment rate and placed in sheet 1 .... Wha
I had done is, it just copied and paste the user name only...

Sample Data in sheet 2:
column A column B
David $20
Dould $30
Owen $20
Hulad $20

How I can do so that when the user select "David" in the comboBox, hi
hourly payment $20 will be select and paste in the column next to hi
username in sheet 1

--
Message posted from http://www.ExcelForum.com