How could i get this complete syntax in vba
- Thread starter Bhawani
- Start date
Ramesh
Active Member
Hi Bhawani,
If I understood your problem correctly, you need some help on syntax to be written while writing the code.
In order to be able to show some help with regards to the syntax, you need to enable Auto Quick Info. To enable the same, follow the steps given below:
1) Open code window / Visual Basic Editor Window
2) Click on Tools menu on the top and select Options
3) In the Options dialog box, ensure you have Auto Quick Info checkbox selected
4) Click on OK
After completing the above said steps, now when you type the method Replace and press space bar, you see a tool tip showing up with the syntax to be followed.
If I understood your problem correctly, you need some help on syntax to be written while writing the code.
In order to be able to show some help with regards to the syntax, you need to enable Auto Quick Info. To enable the same, follow the steps given below:
1) Open code window / Visual Basic Editor Window
2) Click on Tools menu on the top and select Options
3) In the Options dialog box, ensure you have Auto Quick Info checkbox selected
4) Click on OK
After completing the above said steps, now when you type the method Replace and press space bar, you see a tool tip showing up with the syntax to be followed.
@ Ramesh/Marc L = Ok thats right, checking vba auto quick info and inner help supported me.
But my concern is little bit different, while random trying shortcuts for vba i found this by pressing F2 and searched for word Replace.
so here if you will see there are below 3 things:-
1. Library
2. Class
3. Member
Now if you will see in bottom-left most column there is a syntax.
from above solution given by Ramesh and Example by me (in attachement above)both are different.
My requirement is range. replace (Find an replace)is there any way to get entire syntax as support to developer.
But my concern is little bit different, while random trying shortcuts for vba i found this by pressing F2 and searched for word Replace.
so here if you will see there are below 3 things:-
1. Library
2. Class
3. Member
Now if you will see in bottom-left most column there is a syntax.
from above solution given by Ramesh and Example by me (in attachement above)both are different.
My requirement is range. replace (Find an replace)is there any way to get entire syntax as support to developer.