I am writing a macro and calling another subroutine from within that macro. The subroutine has around 3 arguments which are integers. The values of the arguments can only be between 1 and 4, each integer denoting a specific case which is handled in the subroutine. While i am typing to call the subroutine, Excel/VBA provides help by displaying the arguments. I want Excel/VBA to display the value of the argument also (e.g. 1,2,3,4).
To clarify, when we insert the SUBTOTAL function in an excel cell, the first argument can take values 1,2,3 etc. each denoting something which is displayed in Excel. Can I achieve something like this when I am typing the subroutine name while writing the macro.
AK
To clarify, when we insert the SUBTOTAL function in an excel cell, the first argument can take values 1,2,3 etc. each denoting something which is displayed in Excel. Can I achieve something like this when I am typing the subroutine name while writing the macro.
AK