View original (French)

Salutation (Mr, Mrs, Ms) does not appear when executing the form

azixe Posted messages 1 Status Member -  
cs_Le Pivert Posted messages 8437 Status Contributor -
Hello,

I'm showing you the screenshot (made with the keyboard on the Print Screen key) of the 'VBA form' I've created with Excel 2019, which I've named



Here is the code: 

Private Sub CommandButton_AjoutJoueur_Click()
'**************************************
'***** Data registration *****
'**************************************

'**** Title *****
ComboBoxCivilite.ColumnCount = 1
ComboBoxCivilite.List = Array("Mr", "Mrs", "Miss")

'Player's Last Name
Cells(1, 2).Value = TextBox_NomJoueur

'Player's First Name
Cells(1, 3).Value = TextBox_PrenomJoueur

'Address
Cells(1, 4).Value = TextBox_Adresse

'Landline
Cells(1, 5).Value = TextBox_TelephoneFixe

'Mobile
Cells(1, 6).Value = TextBox_TelephoneMobile

'Email
Cells(1, 7).Value = TextBox_Email

Unload UserForm1

UserForm1.Show

End Sub


The form displays, but the Title (Mr, Mrs, Miss) that should be displayed one below the other..... unfortunately, does not appear in the ComboBox

Please help me.
Thank you.

1 answer

Answer 1 / 1
cs_Le Pivert Posted messages 8437 Status Contributor 730
 
Hello,

see this:

https://codes-sources.commentcamarche.net/forum/affich-10100837-userform-formulaire-apres-execution-impossible-d-afficher-la-civilite#p10100840

--
@+ The Woodpecker
0