VBA Functions for use in Worksheet

  • Thread starter Thread starter ZootRot
  • Start date Start date
Z

ZootRot

MS Excel 2002 SP2

I've written a function in VBA, and I can't seem to access it from
worksheets as I would with a traditional excel function, eg =sum(...)

Any suggestions what I am doing wrong?
 
1. Select the Past Function toolbar button.
2. Select User Defined category.
3. Find your function on the right.
4. Fill in the arguments

HTH
Paul
 
Zoot,

Is your code in a normal code module?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Public Function MyFunction()
'....
End function

Regards
BrianB
===============================
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
index function in vba 3
Using VBA functions in MS Excel 4
excel spreadsheet functions written in vba 1
VBA Error Handling 4
VBA Countif across sheets? 5
Excel crashes and restarts when accessing newly created worksheet 2
Using TEXT function in VBA 8

Back
Top