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

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" <(E-Mail Removed)> wrote in message
newsD21CA1E-0A60-42AB-A820-(E-Mail Removed)...
> 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

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" <(E-Mail Removed)> wrote in message
> newsD21CA1E-0A60-42AB-A820-(E-Mail Removed)...
> > 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
>
>

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" <(E-Mail Removed)> wrote in message
news:3E194EAA-6A64-4A81-AFB0-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> newsD21CA1E-0A60-42AB-A820-(E-Mail Removed)...
>> > 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
>>
>>

Thanks

I knew this I don't know what I was thinking.

I have created an excel form that will be used by 5 agents. How can I get
their spreadsheets to automatically update the master file on the “Z drive”?
Also How can I create a form to “search” this master file for the customer’s
number. Once it is found to view, pull through into a form, the associated
other fields related to the customerIDnumber.

Can you help?


"Rick Rothstein (MVP - VB)" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:3E194EAA-6A64-4A81-AFB0-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> >> newsD21CA1E-0A60-42AB-A820-(E-Mail Removed)...
> >> > 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
> >>
> >>
>
>

I can't answer your questions as I don't have a network available to me, so
I am not sure about any locking mechanisms (if any) or security protections
(if any) that may be in place to protect the file from multiple write
collisions. My suggestion would be to ask these question in a new message so
that it might be viewed by the entire group of volunteers again (some may
conclude that our several exchanges is taking care of your original problem
and some of them may no longer be reading this thread).

Rick


"Albert" <(E-Mail Removed)> wrote in message
news6DEF588-80A6-4736-9116-(E-Mail Removed)...
> Thanks
>
> I knew this I don't know what I was thinking.
>
> I have created an excel form that will be used by 5 agents. How can I get
> their spreadsheets to automatically update the master file on the “Z
> drive”?
> Also How can I create a form to “search” this master file for the customer’s
> number. Once it is found to view, pull through into a form, the
> associated
> other fields related to the customerIDnumber.
>
> Can you help?
>
>
> "Rick Rothstein (MVP - VB)" wrote:
>
>> 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" <(E-Mail Removed)> wrote in message
>> news:3E194EAA-6A64-4A81-AFB0-(E-Mail Removed)...
>> > 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" <(E-Mail Removed)> wrote in message
>> >> newsD21CA1E-0A60-42AB-A820-(E-Mail Removed)...
>> >> > 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
>> >>
>> >>
>>
>>