All Questions
209
questions
0
votes
1
answer
47
views
VBA - Wanted: Getting UserForm Object giving its name
is it possible to have a function getting given a string indicating an Object's name then returning corresponding UserForm Object as a result?
Function foo(name as string) as Object
dim Obj as ...
-1
votes
1
answer
129
views
Rotated images with userform
i have a big problem and I need your help.
I have a program with Excel and I use a Userform with an Image control.
When I add images to this control, most of times, images are being rotated.
I need ...
0
votes
0
answers
349
views
Change font size in format control shape Excel
I have a series of Control shapes in an Excel workbook. They are populated by another range, and selections/visibility are controlled by buttons on the sheet. I want to change the font size and ...
0
votes
1
answer
120
views
Excel VBA - Remove slicer right click menu options
I would like to remove options from the menu that pops up when you right click a slicer.
More specifically, I would like to remove "Remove", "Cut", "Refresh", the two ...
1
vote
0
answers
94
views
Accessing controls within worksheet embedded Microsoft Forms 2.0 Frame
I need to know how to access the controls placed within a frame control I placed directly into a worksheet...
Per the suggestion of another Q&A site, I added a Frame Control to a worksheet by ...
2
votes
2
answers
311
views
Excel VBA: Frame doesn't appear in front of ListBox
I have a Frame containing other controls, and I have ListBox. All of these are within a Userform. Initially, the Frame is invisible, and there is a button which toggles its visibility. I want the ...
1
vote
1
answer
38
views
How to cast worksheet type variable into Sheet1 type Object instance
There are 8 sheets with several different ActiveX comboboxes in each. Some comboboxes are able to filter the list of options of remain comboboxes. The logic behind controls are rather similar between ...
0
votes
0
answers
43
views
Excel recognize wrong object at runtime when userform is setup
I have this code initialize an userform. It crashes Excel sometimes (there are times it doesn't crash :|). After awhile of hunting, it turns out that the code get error because Excel recognizes a ...
0
votes
1
answer
64
views
is there a way to save time writing a repeated event procedures, and do it in a function or class
I have multiple controls in a form in MS. Access, that when they receive focus the border width and color would change, just to make my end user see where is the focus at.
I tried so many ways, I ...
1
vote
1
answer
145
views
Excel VBA code to extract data from an HTMLSelect control
I'm creating a macro that works on an Excel spreadsheet into which has been pasted data from a webpage. I want to extract information from the spreadsheet. One piece of information I want is ...
1
vote
1
answer
93
views
Reset all control on ActiveSheet
I need to reset all controls on Activesheet (not a userform) to null.
I tried to loop using ( OLEObject or Controls) but I got :
Run-time error '438': Object doesn't support this property or method.
...
0
votes
0
answers
138
views
Why looping via shapes in Excel VBA gives 1004 error?
I have written the following procedure that is run by clicking customized icon on customized tab.
The procedure is supposed to:
find row and column of a cell that is the (TopLeft) closest to the ...
0
votes
0
answers
212
views
Can I use VBA in MS Access to add a control to a tab control (TabCtl) object?
I want to use VBA in MS Access to dynamically add a subform control to a tab control object on a form. Basically, I have a 99% working solution where users need to generate a custom form. They can ...
1
vote
1
answer
193
views
'Jump to' text box that is off the screen
I have an Excel worksheet that has a good number of rows - so it's pretty long. There are text boxes and buttons scattered throughout.
I set the tab order and that works, except for one problem. If ...
0
votes
0
answers
187
views
VBA Common Control On Others PC
I need information.
I am work on Microsoft Excel 365 (2016 32 Bit) and I have registered and installed mscomctl.ocx sp6 to get some additional control on my VBA project such as Date Picker, Listview ...