View Full Version : Solved: Similar case

04-22-2010, 01:43 AM
This particular case is very close to what I intend to achieve but in a different manner. To learn VBA, I'm developing a small application.

There are two specific comboboxes in the Sheet MAIN. I want them to be populated with the latest data everytime user opens it. I tried to use the above logic.

Private Sub Workbook_Open()
Call Add_Entry
End Sub

This I have placed in module 1. This probably is downright simple for most of the VBA coders but not for me. Any guidance will be appreciated.

04-22-2010, 10:16 PM
I was hoping for some start point.

04-22-2010, 11:20 PM
Try this thread (http://www.vbaexpress.com/forum/showthread.php?t=31664)

04-23-2010, 12:21 AM
Thank you mdmackillop. I placed the sub routine in 'this workbook' and it worked fine.