Excel vba fill combobox in workbook_open

Dev Shed Forums Sponsor:

April 3rd, 2012, 06:34 AM

oyb1n

Registered User

Join Date: Nov 2011

Posts: 17

Time spent in forums: 3 h 1 m 53 sec
Reputation Power: 0

Excel vba fill combobox in workbook_open

Hey,

Having some problems filling a combobox with content when using the workbook_open sub()

I got the combobox to work well when I had it in a sub under sheet1, but it's important that it runs when opening the document.

Code:

Private Sub workbook_open() Sheets("Sheet1").Combobox1.List = Array("Januar", "Februar", "Mars", "April", "Mai", "Juni", "Juli", "August", _ "September", "Oktober", "November", "Desember") End Sub

Tried

Code:

Sheets("Sheet1").select

then did did the combobox code again, don't see whats the problem here?

Viewing: Dev Shed Forums > Programming Languages - More > Visual Basic Programming > Excel vba fill combobox in workbook_open

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump