/ Forside / Teknologi / Administrative / MS-Office / Nyhedsindlæg
Login
Glemt dit kodeord?
Brugernavn

Kodeord


Reklame
Top 10 brugere
MS-Office
#NavnPoint
sion 18709
refi 14474
Klaudi 9389
Rosco40 5695
berpox 5456
dk 5398
webnoob 4919
Benjamin... 4870
o.v.n. 4637
10  EXTERMINA.. 4373
how to program a button...
Fra : Verner Jensen, Ålbor~


Dato : 09-05-05 13:42

Howdy !

Is it possible to have a button on a menubar calling a function in an .xla?

Rgds, Henrik



 
 
Bob Phillips (09-05-2005)
Kommentar
Fra : Bob Phillips


Dato : 09-05-05 13:49

Yes, just create it within the workbook_Open event of the xla.

--
HTH

Bob Phillips

"Verner Jensen, Ålborg" <java@ofir.dk> wrote in message
news:427f5a7b$0$78283$157c6196@dreader1.cybercity.dk...
> Howdy !
>
> Is it possible to have a button on a menubar calling a function in an
..xla?
>
> Rgds, Henrik
>
>



Tom Ogilvy (09-05-2005)
Kommentar
Fra : Tom Ogilvy


Dato : 09-05-05 13:55

If you assign the onaction property of the button to the code in the xla.
It can also be done manually although you would not be able to select it
from the choices in the dialog box - you could still type in the reference.

--
Regards,
Tom Ogilvy

"Verner Jensen, Ålborg" <java@ofir.dk> wrote in message
news:427f5a7b$0$78283$157c6196@dreader1.cybercity.dk...
> Howdy !
>
> Is it possible to have a button on a menubar calling a function in an
..xla?
>
> Rgds, Henrik
>
>



Andy Wiggins (09-05-2005)
Kommentar
Fra : Andy Wiggins


Dato : 09-05-05 15:03

This file might be a help:

It contains a workbook that shows how to create an interactive add-in
controlled by a toolbar.
The toolbar is created when the add-in is loaded, and deleted when the
add-in is closed.

http://www.bygsoftware.com/examples/excel_addin.htm
The code is open and commented.


--
Regards
-
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy


"Verner Jensen, Ålborg" <java@ofir.dk> wrote in message
news:427f5a7b$0$78283$157c6196@dreader1.cybercity.dk...
> Howdy !
>
> Is it possible to have a button on a menubar calling a function in an
..xla?
>
> Rgds, Henrik
>
>



Søg
Reklame
Statistik
Spørgsmål : 177558
Tips : 31968
Nyheder : 719565
Indlæg : 6408925
Brugere : 218888

Månedens bedste
Årets bedste
Sidste års bedste