Excel 97 - extract data from COMBO BOX to Database
 

I've been having quite a bit of fun.

Need to get a formula working that will extract the choice selected i
a combo box in Excel 97 to another sheet within the same file.

Here's a quick summary:
1. Excel 97 (soon to be Excel 2002)
2. Need formula to extract "selection" of combo box to a database shee
within the same excel file.
3. The page with comboboxes is labeld "MR"
4. The database page is "CentralDatabase"
5. Combo Box has been labeled "Combobox1"
6. The Combo Box pulls from data on "Data" sheet in file.

7. The formula currently looks like this:

**************
Sub Control_on_worksheet()
Dim mypick As Variant
Sheets("CentralDatabase").Range("D4") = Combobox1.Value
' Empty out the drop-down.
End Sub
**************

Something is missing.

Dan
:mad: :confused

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