ComboBox & ListBox problem
Hi,
try somthing like
if me.combobox1.value = "Dave" then
sheets(1).cells(yourow, your colum).value = 20
else if me.comobo1.value = "next" then
and so on
if i was you though, i would bet up each user with a seprate part on
the sheet, say 10 cols ecah, then you could just fill down the hourly
rate colum, and...
to show what they had entred, use
if combobox.value = "Dave" then
hide cols not for this person
etc.
not very good, becasue the perosnse could easily pick some else name,
so you may need to issue passwords?,
you should also use the very hiden method to hide the workbook, and
copy the data accross when a user request it.
Good Luck
Ross
|