excel functions to VBA functions

F

friel300

Board Regular
Joined
Jan 22, 2008
Messages
69
i have come across a couple of times instances where there is a VBA function that does the same job as a function in excel

like
ASC
does tthe same as CHAR but it does it in VBA before going on to the sheet
my Question is
is there a way to get a list of ALL of the functions like this that exist in VBA???
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Sort by date Sort by votes
Go to VBA help and search for "List of Worksheet Functions Available to Visual Basic"
 
Upvote 0
hmm thats good but they seem to only work in excel not vba
is there a way to do this without actually writing anything on the sheet??

and also the example wasnt there so this meens that there will be others that will not be there aswell.

any other places that i could look?
 
Upvote 0
You must log in or register to reply here.

Similar threads

L
  • Question
Hover Function in Excel Similar to PowerBI
Replies
0
Views
263
Lali2023
L
P
  • Question
Word create or open with VBA functionality?
Replies
1
Views
205
SamDsouza
S
frabulator
  • Solved
Call a function from an Add-in to a Macro?
Replies
3
Views
234
Domenic
D
E
  • Solved
Can I use an IsFormula function in a VBA routine?
Replies
4
Views
135
Snakehips
Snakehips
ExcelNooberino
  • Question
Connect Excel with Host On Demand/IBM SuperSession v310
Replies
0
Views
90
ExcelNooberino
ExcelNooberino

Forum statistics

Threads
1,215,214
Messages
6,123,661
Members
449,114
Latest member
aides

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top