control

Hi Everyone, I am attempting to change the background color on my format control button but I do not see an option to do so. Is this only available for the format control text box and option button? Regards, Dastnai

Hi I inserted 4 options control (Developer-->Insert). I liked them to cell K1 1) What is the capital of USA () NY () Whatever () DC () etc When I click on first option, K1 value becomes =1 , if click on second option K1=2 etc Now I want to create a new question and insert new set of option...

I want to load picture userform image control form sheet range & When I clicked listbox then show on image control picture....please some one help me:confused:

Dear Mr.Excel, Happy Holidays; In my Add-In I monitor the SheetActivate event, and create an OLE control by calling active sheet's .OLEObjects.Add() method. When the sheet de-activates its SheetDeactivate event is fired and I need to delete the control by calling its .Delete() member. Excel is...

When you have 2 frames in a userform overlapping, how do you control which frame is on top?

Hi, I manage an area with quite a number of VBA workbooks floating around. Everyone seems to be editing these on the fly and creating more workbooks coding from scratch but steeling (copy paste) from other workbooks. Can someone please refer me to a process, body of knowledge or other that can...

Hi Guys, I have been chasing my tail on this one. I have a chart and I want to place a "label" on it using a textbox. I need to make the background of the textbox white and the text black. here is the code I have. Sub Sticker() With...

Hey everybody, I'm new to this forum, so I apologize if this isn't where I should post this question. I'm currently taking an intro to excel class at school, and am stuck on an assignment. I really have no idea what I'm doing wrong, because as far as I can tell, I followed the instructions...

I am still learning to code and I don't yet know how to delete all the active x control images on a worksheet. Could someone help me please?

I'm using 3 refedit controls in a form and for some reason I can't figure out how to get it to trigger an event when the value of the control is changed. What I'd like to do is make it trigger an event so that when someone clicks onto the worksheet to change the range, it would cause the focus...

Can you control a cells value( scientific notation ) with for example the spin control to scroll for example from <colgroup><col width="709"></colgroup><tbody> 1.00E+01 1.00e+02 1.00e+e03 etc im using this cell as an input into a much larger set of data that will change as you spin up...

Hi, I'am trying to set up an excel tot make our office more paperless Documents will be stored in the cloud (OneDrive) synchronised Locally. Excel file should provide organised acces to the files. I already have a userform with a Webbrowser Control to preview documents chosen from a listbox...

Hi Is possible to have a datepicker (or maybe just another control like button etc) in a listox or listvew control for every item? And if yes, how is that done. Thanks for any hit/help.

Hello, I'm very basic at form usage. My question is, how do I total a control field with criteria of another field. My simple calculation in the control field is =Sum([Sales]). What I want to achieve is to only sum [Sales] if [Account] = X Many thanks.

Hello, I have a problem statement. I need to filter data based on specific characteristics. So characteristics is in column 1 ( A24:A258). I need a method and code to add a separate activex control so as to filter the data based on these characteristics. The problem I am getting is I have 3...

I have an image file in JPG format, 8MB in size. When I try to load this into an image control of a userform, the picture is not scaling to the image control size, despite all values of the options of "PictureSizeMode". The picture seems to be much bigger beyond the size of the image control and...

Is there a way to insert a png file into an active x control?

Hi, Anyone have any idea why it is I have two up arrows and two down arrows in a form control combobox scrollbar? As shown in image. Thanks in advance!

Hi There I don't know how to download or install programs from the internet. My Excel 16 does not have the following: Microsoft Date and Time control Microsoft Monthly View Control. I need at least one of these controls to do a pop up calendar and it is too complicated for me to download...

My Control File contains several worksheets. It links to data in other files in same folder. Just having problem with updating links with auto updating and returning to Control File.xlsm Tried this but need files to save and close except Control File.xlsm after updating. Is that possible...