{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Liste de Contacts","Cliquer sur le bouton "],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Liste de Contacts","index":0,"n_rows":303,"n_cols":14,"rows_kept":303,"cut":false,"hidden":false,"merged":[[3,3,5,3],[3,4,4,5],[3,6,3,12],[3,13,5,13],[4,6,4,10],[4,11,4,12]]}
[null,null,1]
[null,1]
[null,{"$f":"$B$2+6","v":7}]
[null,null,null,"Photo","Nom",null,"Numéro de Téléphone",null,null,null,null,null,null,"Email"]
[null,null,null,null,null,null,"Portable",null,null,null,null,"Fixe"]
[null,null,null,null,"Nom ","Prénom","№ 1","№ 2","№ 3","№ 4","№ 5","№ 1","№ 2"]
[null,7,2,null,"qze","sff",null,null,null,null,null,null,null,"BSD<VSD<VSD"]
[null,{"$f":"IF(AND(E8=\"\",F8=\"\"),0,IF(AND(E8>0,F8=\"\"),1,IF(AND(E8=\"\",F8>0),1,IF(AND(E8>0,F8>0),1))))","v":1},3,null,"wxc","zGAZ",14,null,null,null,null,18]
[null,{"$f":"IF(AND(E9=\"\",F9=\"\"),0,IF(AND(E9>0,F9=\"\"),1,IF(AND(E9=\"\",F9>0),1,IF(AND(E9>0,F9>0),1))))","v":0},4]
[null,0,5]
[null,0,6]
[null,0,7]
[null,0,8]
[null,0,9]
[null,0,10]
[null,0,11]
[null,0,12]
[null,0,13]
[null,0,14]
[null,0,15]
[null,0,16]
[null,0,17]
[null,0,18]
[null,0,19]
[null,0,20]
[null,0,21]
[null,0,22]
[null,0,23]
[null,0,24]
[null,0,25]
[null,0,26]
[null,0,27]
[null,0,28]
[null,0,29]
[null,0,30]
[null,0,31]
[null,0,32]
[null,0,33]
[null,0,34]
[null,0,35]
[null,0,36]
[null,0,37]
[null,0,38]
[null,0,39]
[null,0,40]
[null,0,41]
[null,0,42]
[null,0,43]
[null,0,44]
[null,0,45]
[null,0,46]
[null,0,47]
[null,0,48]
[null,0,49]
[null,0,50]
[null,0,51]
[null,0,52]
[null,0,53]
[null,0,54]
[null,0,55]
[null,0,56]
[null,0,57]
[null,0,58]
[null,0,59]
[null,0,60]
[null,0,61]
[null,0,62]
[null,0,63]
[null,0,64]
[null,0,65]
[null,0,66]
[null,0,67]
[null,{"$f":"IF(AND(E73=\"\",F73=\"\"),0,IF(AND(E73>0,F73=\"\"),1,IF(AND(E73=\"\",F73>0),1,IF(AND(E73>0,F73>0),1))))","v":0},68]
[null,0,69]
[null,0,70]
[null,0,71]
[null,0,72]
[null,0,73]
[null,0,74]
[null,0,75]
[null,0,76]
[null,0,77]
[null,0,78]
[null,0,79]
[null,0,80]
[null,0,81]
[null,0,82]
[null,0,83]
[null,0,84]
[null,0,85]
[null,0,86]
[null,0,87]
[null,0,88]
[null,0,89]
[null,0,90]
[null,0,91]
[null,0,92]
[null,0,93]
[null,0,94]
[null,0,95]
[null,0,96]
[null,0,97]
[null,0,98]
[null,0,99]
[null,0,100]
[null,0,101]
[null,0,102]
[null,0,103]
[null,0,104]
[null,0,105]
[null,0,106]
[null,0,107]
[null,0,108]
[null,0,109]
[null,0,110]
[null,0,111]
[null,0,112]
[null,0,113]
[null,0,114]
[null,0,115]
[null,0,116]
[null,0,117]
[null,0,118]
[null,0,119]
[null,0,120]
[null,0,121]
[null,0,122]
[null,0,123]
[null,0,124]
[null,0,125]
[null,0,126]
[null,0,127]
[null,0,128]
[null,0,129]
[null,0,130]
[null,0,131]
[null,{"$f":"IF(AND(E137=\"\",F137=\"\"),0,IF(AND(E137>0,F137=\"\"),1,IF(AND(E137=\"\",F137>0),1,IF(AND(E137>0,F137>0),1))))","v":0},132]
[null,0,133]
[null,0,134]
[null,0,135]
[null,0,136]
[null,0,137]
[null,0,138]
[null,0,139]
[null,0,140]
[null,0,141]
[null,0,142]
[null,0,143]
[null,0,144]
[null,0,145]
[null,0,146]
[null,0,147]
[null,0,148]
[null,0,149]
[null,0,150]
[null,0,151]
[null,0,152]
[null,0,153]
[null,0,154]
[null,0,155]
[null,0,156]
[null,0,157]
[null,0,158]
[null,0,159]
[null,0,160]
[null,0,161]
[null,0,162]
[null,0,163]
[null,0,164]
[null,0,165]
[null,0,166]
[null,0,167]
[null,0,168]
[null,0,169]
[null,0,170]
[null,0,171]
[null,0,172]
[null,0,173]
[null,0,174]
[null,0,175]
[null,0,176]
[null,0,177]
[null,0,178]
[null,0,179]
[null,0,180]
[null,0,181]
[null,0,182]
[null,0,183]
[null,0,184]
[null,0,185]
[null,0,186]
[null,0,187]
[null,0,188]
[null,0,189]
[null,0,190]
[null,0,191]
[null,0,192]
[null,0,193]
[null,0,194]
[null,0,195]
[null,{"$f":"IF(AND(E201=\"\",F201=\"\"),0,IF(AND(E201>0,F201=\"\"),1,IF(AND(E201=\"\",F201>0),1,IF(AND(E201>0,F201>0),1))))","v":0},196]
[null,0,197]
[null,0,198]
[null,0,199]
[null,0,200]
[null,0,201]
[null,0,202]
[null,0,203]
[null,0,204]
[null,0,205]
[null,0,206]
[null,0,207]
[null,0,208]
[null,0,209]
[null,0,210]
[null,0,211]
[null,0,212]
[null,0,213]
[null,0,214]
[null,0,215]
[null,0,216]
[null,0,217]
[null,0,218]
[null,0,219]
[null,0,220]
[null,0,221]
[null,0,222]
[null,0,223]
[null,0,224]
[null,0,225]
[null,0,226]
[null,0,227]
[null,0,228]
[null,0,229]
[null,0,230]
[null,0,231]
[null,0,232]
[null,0,233]
[null,0,234]
[null,0,235]
[null,0,236]
[null,0,237]
[null,0,238]
[null,0,239]
[null,0,240]
[null,0,241]
[null,0,242]
[null,0,243]
[null,0,244]
[null,0,245]
[null,0,246]
[null,0,247]
[null,0,248]
[null,0,249]
[null,0,250]
[null,0,251]
[null,0,252]
[null,0,253]
[null,0,254]
[null,0,255]
[null,0,256]
[null,0,257]
[null,0,258]
[null,0,259]
[null,{"$f":"IF(AND(E265=\"\",F265=\"\"),0,IF(AND(E265>0,F265=\"\"),1,IF(AND(E265=\"\",F265>0),1,IF(AND(E265>0,F265>0),1))))","v":0},260]
[null,0,261]
[null,0,262]
[null,0,263]
[null,0,264]
[null,0,265]
[null,0,266]
[null,0,267]
[null,0,268]
[null,0,269]
[null,0,270]
[null,0,271]
[null,0,272]
[null,0,273]
[null,0,274]
[null,0,275]
[null,0,276]
[null,0,277]
[null,0,278]
[null,0,279]
[null,0,280]
[null,0,281]
[null,0,282]
[null,0,283]
[null,0,284]
[null,0,285]
[null,0,286]
[null,0,287]
[null,0,288]
[null,0,289]
[null,0,290]
[null,0,291]
[null,0,292]
[null,0,293]
[null,0,294]
[null,0,295]
[null,0,296]
[null,0,297]
[null,0,298]

{"sheet":"Cliquer sur le bouton ","index":1,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,4,6],[15,0,15,9],[7,7,12,10]]}
["         j'ai créer une liste de contacts dans la feuil \"liste de contacts\" et lui est affecté le macro qui me permet de trier par ordre alphabétique automatiquement.\n        j'ai créé un bouton sur la feuil \"cliquez sur le bouton\" et lui est affecté le UserForm \"modifier le contact\",  quand je clique sur lui il m'affiche sans problème la boîte de dialogue suivante :"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Remarque : quand je crée j'ai créer un bouton sur la feuil \"liste de contacts\" et lui affecte le UserForm \"modifier le contact\", il y a aucun problème quand je clique sur lui."]
[]
[]
[]
[]
[]
[]
[]
[" mais quand je clique sur le ComboBox (ComboBox_Nom) et je choisi l'un des contacts il m'affiche l'erreur suivante :"]