xaddress

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

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

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

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