View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
ross ross is offline
external usenet poster
 
Posts: 81
Default 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