NUMBER OF COMMANDS

  • Thread starter Thread starter RAJEEV CHADHA
  • Start date Start date
R

RAJEEV CHADHA

Hi,
Can anyone tells me that how many total built in commands are there in excel.

Rajeev
 
Hi

Run this macro

Sub test()
Dim Cbar As CommandBar
Dim BCOUNT As Long
BCOUNT = 0
For Each Cbar In Application.CommandBars
If Cbar.BuiltIn = True Then
BCOUNT = BCOUNT + 1
End If
Next
MsgBox BCOUNT
End Sub
 
do you mean functions like SUM ...

if so then from help (Excel specifications and limits)

Number of available worksheet functions 329


the analysis toolpak gives, i believe, an additional 110
 
Hi

My example is for the CommandBars
I see you want it for controls (which CommandBar and why ?)
 
Number of available worksheet functions 329

Ahaaa

Forget my answer(this is not programming <g>)
 
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

CONVERTING NUMBER TO TEXT 3
Rows to repeat at the bottom 3
help needed with taskbar 1
MACRO LEARNING 4
INCREASING SPACE FOR CUSTOMISE HEADER 2
Stock Reconciliation 1
Excel Calculation 9
Excel Subtracting multiple columns from another column 3

Back
Top