Re: MAKRO do excelu

From: ov <o.vahalik (zavinac)>
Date: 26. 04. 2005, 07:38 CEST
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