relative position

Hello, I have an Excel 2013 worksheet that has several paired Check Boxes and List Boxes on it. When a check box is clicked, its paired list box becomes visible. If it is not checked, its paired list box is not visible. I would like the check box/list box pairs to move up or down on the sheet...

Hi, I am really struggling to figure out how to move a picture to the bottom left of the windows screen in VBA. Would love it if someone could provide some insight (would also love to know if it is possible to keep it there (even if user scrolls or zooms the screen). Thanks, Geoff.

Hi, I'm trying to fill some cells in a spreadsheet with formulas, as the input can be changed after the routine has run. The following works: Range("F34:F" & lastrow).Formula = "=IF(E34=""Yes"",0,D34*$D$9)" but the below, set up along the same lines, generates an error; Range(("F" &...

Hello, I have a bulleted list of various treatment options which changes depending on the parameters entered. The bullets are derived using VBA code and output into a single Excel spreadsheet cell. The list bullets are each on a separate line using the vbNewLine code, e.g., (the code has been...

I have background sheets that make calculations based on input data that is found on each row of the main sheet. I created a ginormous macro that basically repeats the same command for a series of 30+ 'If/ If Else statements' where it finds the right background sheet for the row and then...

Here is a sample of the data I am using. Excel 2010ABCD1Myfolder58002Bin18003de400004en500005Random150436Random25044Sheet1 I am importing it from a text file that is pipe delimited. The data represents a folder structure. Items in the same column are on the same level, those that are 1+...

Hi, I have a spreadsheet that has some values in cells A1:E1 (let's call these base values 1) The values in cells A2:A10 are calculated using the base values in A1:E1 So, the formulas is A2:A10 might look something like this... A2 = ($A$1 + $B$1 + $C$1 + $D$1 + $E$1) * 1 A3 = ($A$1 + $B$1 +...

Hi, I am trying to Automate filling a Column with a correct format date when I download a sheet with dates in the Format 'YYYYMMDD'. What I am trying to Do: Insert Column, Insert Formula, Autofill to bottom of Data, Copy Results and Paste as Values, Convert to Excel Date Formatting. Delete...

I have a CSV file that has data exported that includes addresses. If the address line had a second row, it is all in one cell with a special character at the end of the first row of data. I am trying to record a macro to remove the special character. I put the cursor in the cell that needs...