Why not just use a lookup in Sheet 1, like
=VLOOKUP(A1,Sheet2!A1:B50,2,False)
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"unplugs " wrote in message
...
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 choose
their name. The row source of the comboBox is refer to sheet2, where
sheet 2 store the user name, and their hourly payment rate. They got 2
different hourly payment rate which is $20 and $30 respectively.
I had tried several methods... But I duno how to do so that when they
select the username that time, it will match the username in sheet 2
and then copy their hourly payment rate and placed in sheet 1 .... What
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, his
hourly payment $20 will be select and paste in the column next to his
username in sheet 1?
---
Message posted from http://www.ExcelForum.com/