Solved: Similar case

[shrivallabha]

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.

[vba]Private Sub Workbook_Open()
Call Add_Entry
End Sub
[/vba]

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.

[shrivallabha]

I was hoping for some start point.

[mdmackillop]

Try this thread

[shrivallabha]

Thank you mdmackillop. I placed the sub routine in 'this workbook' and it worked fine.