I have the following code and it works if the only thing i list is the font size. When i add the height and width i get an error. Run- time error '438': Objest doesnt support this property method.
is there anything i can do to get my active x list boxes to stop resizing?
I sent the integral...
i am working on active x control and chart but i need true guide lines.
i) In spread sheet i need to a Date list Box (Active x control) for date selection like 12-Mar-2018.
ii) In Second thing i need to select in chart (Bar Chart) From Table 1 and Table 2.
I did some reading online about this and can't seem to find a direct clear answer.
I have CheckBoxes and Command Buttons (Active X Control) on multiple excel sheets. I noticed that when a user who has a different screen size/resolution than me clicks on those buttons, the buttons...
I did a presentation yesterday demonstrating a spreadsheet I have designed. It works perfectly on my widescreen monitor. Unfortunately, the presentation had to be done on a projector and the best aspect ratio was 4:3 not 16:9.
At first this didn't pose much of an issue as I have code to...
Good day all, </SPAN>
At the moment I am working on a project to create quotations.
I have one “Fill in” file, which will be used by several people. This file consists of Cells which have to be filled in, drop down functions and Active X Controls (drop down functions)...
I'm an absolute VBA novice and am stuck with some code that I've been give to output multi listbox selections into a single cell. I've searched for an age to find an explanation I can understand but failed miserably - please help me retain my sanity :banghead:
Everything works well until...
I have made a template In which i have Inserted Image(Active X Control)
and put a code in duble click event to select "Image1.Picture = LoadPicture(Application.GetOpenFilename) "
Its working fine but problam is file size become somuch bigger then normal even image size in kb, I can't...
This code is perfect but I would like it to perform on all sheets, rather than just the active.
'Loop through the Shapes collection and use the Type number of the control
Dim myshape As Shape
For Each myshape In ActiveSheet.Shapes
' ActiveX control (control...
Hello. I'd like to use VBA code to filter a data set. This is probably a simple question for most, but I'm a VBA newbie.
I want to use an Active X Control to change the value of cell C2 to 1. If cell C2 is equal to 1, I want my code to filter for 'does not equal' 0. I can set up the...