control

  1. D

    Format Control Button

    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
  2. L

    option control link

    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...
  3. M

    Activex Image Control

    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:
  4. S

    deleting OLE control from inactive worksheet

    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...
  5. M

    Controlling frame order

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

    Version control and modular design

    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...
  7. R

    Change the background color of a textbox that is positioned in a chart

    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...
  8. S

    Combo Box help

    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...
  9. D

    I need the vba code to delete all the active x control images on a worksheet

    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?
  10. M

    Triggering Refedit change event

    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...
  11. D

    Using form controls with scientific notation

    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...
  12. D

    View PNG in Webbrowser control

    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...
  13. G

    Datepicker in a listbox/listview second column

    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.
  14. R

    Form Control Field - Sum criteria

    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.
  15. S

    Adding filter by either using combo or list activex control to filter dynamic data

    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...
  16. S

    Resize picture to fit the image control in userform

    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...
  17. D

    png files inserted into excel

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

    Two up & down arrows in form control combobox

    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!
  19. P

    Pop up Calendar

    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...
  20. syndee

    Updating links with auto updating

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top