You can not use the VB toolbox to modify a (designer) VBA UserForm.
VBA userforms, and controls are different components as opposed to native VB
forms/controls.
You can however, use the VBA toolbox and modify those.
The VBA toolbox isn't available in the toolbars and menus, but you can bring
it up by:
In the Project browser click on another object and then click on yr designer
Userform object.
This should normally popup the VBA controls toolbox and y're set.
If this doesn't work, do either of two below options.
Note: make a safe backup of yr VB project, before using below steps.
1) try to remove the designer VBA userform and reimport.
2) try to export under a different name and import the newly created one.
When exporting the designer userform, set File Type to ("*.* | All Files) in
the SaveAs dialog and give the userform a new name with the .FRM extension
Remove the designer userform from the VB project and (re)add the newly
created .FRM file in yr VB Project.
This should definitely bring the VBA toolbox.
-------------------------------------
Krgrds,
Perry
System parameters:
POS: WinXP SP2
MSO: MSOffice 2003 SP2
DEV: VS8 (dotnet)
-------------------------------------
> Hi All,
>
[quoted text clipped - 7 lines]
>
> Elliot
Perry - 30 Dec 2005 10:17 GMT
And check whether the MS Forms library is activated:
Rightclick the VB Toolbox to add extra Components.
In the next dialog, choose the Designers tab and check the MS Forms 20 item
(if at all this options is already checked)
Hit OK to validate yr setting.
-------------------------------------
Krgrds,
Perry
System parameters:
POS: WinXP SP2
MSO: MSOffice 2003 SP2
DEV: VS8 (dotnet)
-------------------------------------
> You can not use the VB toolbox to modify a (designer) VBA UserForm.
> VBA userforms, and controls are different components as opposed to native
[quoted text clipped - 39 lines]
>>
>> Elliot
Elliot - 30 Dec 2005 22:26 GMT
Will try, thanks for the help