UPSC :- Paper Notice and syllabus : Competitive Book :- Important Project :- Purvanchal University Book : Youtube Class Note : TGT/PGT Note and Previous Year paper : TGT/PGT Chemistry Note : Vipin Sir Class Test
Total three type point to discuss about it .
1. Who to open Web Browser in MS Excel User Form :-
In this point I would solved the problem in step by step.
Step 1. :-
The fist problem is that web browser in not add in toolbox Then Go to the toolbox and Right click Just like the given picture.
Open the window just like The given above . Then click the Additional Controls . when you click the Additional Controls Then new window open like it.
when Available control window is open then click the Microsoft web browser . when you check the Microsoft web browser , web browser icon is add in the toolbox.
Step 2.:-
when web browser is add in the too box then design the user form . Like UserForm name is UserForm1 and web Browser name is web Browser 1 and make a TextBox name is TextBox 1 and command button name is CommandButton1 .
Design is show like below windows.
whit area is web browser area .
2. Who to code to open the Web Browser :-
Double click the Search Command Button and write the code given below.
Private Sub CommandButton1_Click()
Me.WebBrowser1.Navigate Me.TextBox1.Value
End Sub
When you write the code and save the module . Then Run the UserForm your web Browser in ready to show the content.
3. Solved the Script error :-
When you run your side in the web browser , browser show the Script Error.
Solved this problem go to the user form and click the web browser the go to the properties, and
Silent properties and Register Browser properties have is True . your Script Error is gown and your web browser work fast .
Some other topics:-
3. Who to Lock your MS Excel File
4. MS Excel UserForm Save And Edit Module Part-1
5. MS Excel UserForm Save And Edit Module Part-2
6.