xaddress

  1. G

    Add checkboxes to Listbox

    I have many checkboxes that I would like to move to a listbox to make things look neater in my spreadsheet. I have never used the listbox but I would like it to include all of my checkboxes with the option to choose multiple checkboxes. I know I must change the properties of the listbox...
  2. G

    Toggle button Macro

    Hi, Below is some VBA code used with a toggle button to hide/unhide rows 8:10. This works perfectly. I need to amend the code so the button hides/unhides rows 16,22,23,26,30,32,46,49,52,55,58 AND Columns G,H,I,J. Private Sub ToggleButton1_Click() Dim xAddress As String xAddress = "8:10" If...
  3. E

    Converting from active x to form controls

    Hello, I have an axtive X toggle button that works pretty slick. It shows and hides a range of rows by use of hidden "addresses" - basically a cell with a range it looks for. Private Sub ToggleButton1_Click() Dim xAddress As String rw1 = ActiveWorkbook.ActiveSheet.Columns(1).Find(99991).Rowrw2...
  4. J

    Rename the pictures using excel

    Hi Guys, I need your help. I'm using mac. I try to figured out for this code for change the old names of picture to new name. Here the the code: Sub PictureNametoExcel() 'UpdatebyExtendoffice201709027 Dim I As Long Dim xRg As Range Dim xAddress As String Dim xFileName As String...

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