Hi,
I purchased a vba book, "MS Excel 2000 Power Programming with VBA" by John Walkenbach. A cd rom comes along with it with spreadsheet examples explained. There's this one workbook in Chapter 3, "Array Examples.xls In tab "Calendar" he has a drop down menu for Months and a scroll bar menu for years. But, I can't figure how he created these. I don't think it was done with VBA programming because when I doubleclicked on these menus, it didn't automatically go to a vba module. Instead, when I double clicked it, a "Format Control" window popped up. The tabs for the window are: Size, Protection, Properties, Web and Control.
When I have the scroll bar selected, the name box (left of the formula bar) displays the name "Scroll Bar 5"; and the formula displays "=TheYear"
(TheYear equals the cell value in cell H16 of the worksheet)
I can select the year by either entering a year in cell H16 - or - by using the scroll bar. The control tab in the "Format Control" window has the following fields: Min value, Max value, Incremental Change, Page Change and Cell Link (= TheYear).
The Drop Down menu (for Months) displays "Drop Down 2" in the named box; and the formula bar has "=TheMonth". The Control tab has the following fields: Input Range = MonthRange (Range("H19:H30"), Cell Link, Drop Down Lines.
Can someone please let to create this...Was this done in VBA? or is there a feature within excel that does this?
I purchased a vba book, "MS Excel 2000 Power Programming with VBA" by John Walkenbach. A cd rom comes along with it with spreadsheet examples explained. There's this one workbook in Chapter 3, "Array Examples.xls In tab "Calendar" he has a drop down menu for Months and a scroll bar menu for years. But, I can't figure how he created these. I don't think it was done with VBA programming because when I doubleclicked on these menus, it didn't automatically go to a vba module. Instead, when I double clicked it, a "Format Control" window popped up. The tabs for the window are: Size, Protection, Properties, Web and Control.
When I have the scroll bar selected, the name box (left of the formula bar) displays the name "Scroll Bar 5"; and the formula displays "=TheYear"
(TheYear equals the cell value in cell H16 of the worksheet)
I can select the year by either entering a year in cell H16 - or - by using the scroll bar. The control tab in the "Format Control" window has the following fields: Min value, Max value, Incremental Change, Page Change and Cell Link (= TheYear).
The Drop Down menu (for Months) displays "Drop Down 2" in the named box; and the formula bar has "=TheMonth". The Control tab has the following fields: Input Range = MonthRange (Range("H19:H30"), Cell Link, Drop Down Lines.
Can someone please let to create this...Was this done in VBA? or is there a feature within excel that does this?