Using VBA functions in MS Excel

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,

I've just strarted using vba function to automate some of my spreadsheets.
I've created a function in a worksheet, but no matter what I try I can't seem
to access the function from a cell - any help would be greatfully accepted
--
Just getting used to VBA!!!

.

Relevant Pages

  • Re: Editing a simple macro
    ... In Excel stick this Sub in a general module ... >the small form part within the worksheet, and then they click on a hyperlink ... >wanted to do the macro was: ... but I'm trying to automate this form to make it as easy ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Editing a simple macro
    ... Part of the worksheet is a small form that requires completion which, ... wanted to do the macro was: ... Copy that cell together with the form ... but I'm trying to automate this form to make it as easy ...
    (microsoft.public.excel.worksheet.functions)
  • Re: First record is always blank
    ... worksheet starting at A1 and including every cell that's ever ... entire UsedRange. ... spreadsheets are basically set up the same way and on all 3 spreadsheets the ... The spreadsheets are created via VBA by ...
    (microsoft.public.access.externaldata)
  • Re: Pocket Excel
    ... specific worksheet. ... I did some further copying of other spreadsheets and ... I believe that it converts it to a pocket excel file in the ...
    (microsoft.public.pocketpc)
  • Re: Excel cant do basic math?!
    ... Doesn't matter what cells I use. ... I can open up a fresh worksheet and put one figure in A1, another in B1, add ... Sum data ... totals are always off by exactly 672. ...
    (microsoft.public.excel.misc)