Enableevents screenupdating

Mais j'aimerai que pour les 2 cas la valeur finale soit 17. Je n'ai pas l'habitude d'écrire sur les forums mais j'aime partager les débuts de solutions que je monte tant bien que mal :). J'ai eu le même problème, c'est peut-être pas la meilleure solution mais voici mon code : A mettre dans un module : Sub test() c = Selection.

The combo box's font size can be set, more than 8 rows can be displayed, and autocomplete can be enabled. Enable Events = False 'get the data validation formula str = Target. Formula1 str = Right(str, Len(str) - 1) With cbo Temp 'show the combobox with the list .

Many thanks to everyone who shared their tips & ideas with us.

If you like the tips, please say thanks to the contributor.

Shrink To Fit = True End With With Range("BL3: CY4") .

Shrink To Fit = True End With With Range("AX7: BW8") .

381

Leave a Reply

  1. Foli sex 02-Jan-2018 03:27

    The subject of the letter includes, the officers tooth ache and extraction, his wifes tooth extraction and gold filling, being charged in error for light blue military pants, studying field and light artillery, and the 1864 election of William Alfred Buckingham as Governor of Connecticut.