how can I create a multiple VBA input list to fill in excel cells

[Gian Capannesi]

I am trying to use VBA to create an input list for multiple cells in a
workbook with multiple sheets for example

date 25th of the month

Chicago - 2000
Denver - 1000
NY - 15000

When I press enter I would like it to fill in the respective cells in the
separate sheets - for the 25th of the month

 

[Jason]

There are several ways on doing it. I usually use the Excel Object Model.
First you have to set a reference to it in Tools>References
Then the VBA code looks something like this:

Dim objWB As Excel.Workbook
Set objWB = GetObject("C:\MyWorkbook.xls")
objWB.Sheets("Sheet1").Cells(5,5) = 2000
objWB.Close true
Set objWB = Nothing

Is this anything like what you wanted?