View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pswanie pswanie is offline
external usenet poster
 
Posts: 247
Default inputbox on userform

i got a listbox to show data from column c. commandbutton1 then put those
names with a tick next to it in a range.

now im gona add commandbutton2 and inputbox1
when the user click commandbutton2 a inputbox1 needs to be enabled for the
user to type in two words. (now commandbutton2 is disabled)

then when the user click commandbutton1 the names from the listbox with a
tick next to it and the one they typed in just now needs to be in sheet1
range d42. and at the same time add the name in inputbox1 to the next empty
cell in colum c on sheet2