On Tue, 26 Apr 2005 07:09:47 +0200, MilanK <milan@kev.sk> wrote: > V suvislosti s tymto makro som narazil na jednu vec. > > Mam v makre: > Sheets(String2).Select > > (String2 je zadaný názov sheetu cez dialogove okno) > > Ako mozem otestovat, ci zadany sheet existuje? Aby som > mohol vypisat chybovu hlasku, namiesto toho aby pri zle > zadanom nazve makro padlo. > > MilanK > A co vybrat sheet z listboxu? umistit na formular listbox1 Sub formular_nacist() dim i as integer, pocetlistu as integer pocetlistu=thisworkbook.sheets.count for i to pocetlistu listbox1.additem(thisworkbook.sheets(i).name) next end sub (snad je to dobre, nesedim u excelu)Received on Tue, 26 Apr 2005 07:38:44 +0200
This archive was generated by hypermail 2.1.8 : 26. 04. 2005, 07:41 CEST