Command Button Problems

Command Button Problems

Post by Cindy M » Sat, 20 Jan 2007 19:52:54

Hi =?Utf-8?B?Q0lPUE1P?=,

You could try asking this question in the following groups:


and a group that deals with scripting for Internet Explorer. I'm not familiar with IE
from the automation side of things, but this sounds as if this library may have been
removed. Possibly for security reasons.

> 1. From the ontrol Toolboxtoolbar click the button icon to insert a >> button in the document. >> 2. Click the esign ModeButton so that black squares that appear on the > > button:> > 3. Double click on the buttons to open the icrosoft Visual Basic Window>
> 4. Select Tool, References, and ensure that icrosoft Internet Controlsi>
> selected, place a checkbox beside it, if necessar>.
> 5. Between the rivate Suband nd Sublines, insert the following t>xt:
> Dim IE As SHDocVw.InternetExpl>rer
> Set IE = CreateObject("Internetexplorer.applicati>n")
> IE.Visible = >rue
> IE.Navigate "Website goes h>re" >>
> However, I am now unable to find icrosoft Internet Controlsin the >ist
> of references, thus my buttons don work on my end or the users. I don>€
> know much the actual creation of the buttons or the code that goes into >hem
> I just follow the steps and it used to work. When I run a debug on it >ets
> stuck at (nternetexplorer.applicati>n

Cindy Meister
INTER-Solutions, Switzerland (last update Jun 17 2005)

This reply is posted in the Newsgroup; please post any follow question or reply in the
newsgroup and not by e-mail :-)

1. Form command button problems - need to change behavior

2. a command button problem

Range r = Connect.myApplication.ActiveCell;
Microsoft.Office.Interop.Excel.Worksheet sht =

Microsoft.Office.Interop.Excel.Shape btn =
sht.Shapes.AddOLEObject("Forms.CommandButton.1", Missing.Value,Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Missing.Value, sht.get_Range(r,
r).Left,sht.get_Range(r, r).Top,
sht.get_Range(r,r).Width, sht.get_Range(r, r).Height);

((MSForms.CommandButtonClass)btn.OLEFormat.Object).Caption = "click_me";

Why is this not working?? How to get an event handler for this button!?

3. change color of command button problem

4. More Custom Command button problems

5. Hyperlink on command button problem

6. Command Button Problem?

7. EMail Command Button Problem

8. Data Access Page (command button problem)

9. Query Command Button Problem

10. Command Button problems

11. Command Button problems when printing

12. Assign Macro to command button Problem

13. command button problem

14. Command Button Problem

15. command button problem