LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,202
Default Combobox drops down blank row

It's the same code you have now, but in a different event procedure...

Private Sub UserForm_Initialize()
ComboReasonforcall.AddItem "SELECT"
ComboReasonforcall.AddItem "General Query"
ComboReasonforcall.AddItem "Non Activation"
ComboReasonforcall.AddItem "Incorrect Handset Delivery"
ComboReasonforcall.AddItem "Incorrect Activation"
ComboReasonforcall.AddItem "Cancellation"
ComboReasonforcall.AddItem "MNP Forms"
ComboReasonforcall.AddItem "Change Details"
ComboReasonforcall.AddItem "Port Activations"
ComboReasonforcall.AddItem "MTN Exception"
End Sub

Rick


"Albert" wrote in message
...
can you give me the code for this event?

"Rick Rothstein (MVP - VB)" wrote:

The Change event of the ComboBox is not a very good place to put the code
that loads up the item for the first time. It's blank to begin with
because
no change has happened yet... type a letter in the text field of the
ComboBox and then drop down the list. I would think the UserForm's
Initialize event would be a better place for your code.

Rick


"Albert" wrote in message
...
Hi Guys,

I am sure I am doing something wrong as my code works on other forms
Private Sub ComboReasonforcall_Change()
ComboReasonforcall.AddItem "SELECT"
ComboReasonforcall.AddItem "General Query"
ComboReasonforcall.AddItem "Non Activation"
ComboReasonforcall.AddItem "Incorrect Handset Delivery"
ComboReasonforcall.AddItem "Incorrect Activation"
ComboReasonforcall.AddItem "Cancellation"
ComboReasonforcall.AddItem "MNP Forms"
ComboReasonforcall.AddItem "Change Details"
ComboReasonforcall.AddItem "Port Activations"
ComboReasonforcall.AddItem "MTN Exception"
End Sub

When I run the form the items don't appear in the combobox.

Any help?

Cheers
Albert




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
csv format drops ending zeros Excel 2007 - CSV format Excel Discussion (Misc queries) 2 June 23rd 09 12:26 PM
SUM fx drops or adds 1 to total bookscoffee Excel Worksheet Functions 3 November 14th 07 12:39 AM
My Cell drops the Zero if it is first. WTT Excel Discussion (Misc queries) 1 August 21st 07 01:26 PM
csv drops decimal places Steve Excel Discussion (Misc queries) 1 June 29th 05 07:06 PM
Remove blank rows from combobox Steph[_3_] Excel Programming 1 June 25th 04 05:37 PM


All times are GMT +1. The time now is 08:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"