selecting

When selecting xlsx files, the VBA project viewer is automatically launched. Can we prevent this knowing that I have one xlsm file in the same folder? Thanks

I have a report that uses a pivotable. There is a filter that encompasses the entire pivot table but is not the pivottable itself. For what I am trying to do with this works great, However when certain slicers are chosen the pivot resets, rows move so the hiden rows no longer align with the...

Hi, I need to print a file in a directory using vba. I know the file path which we can call FilePath. The difficult part is selecting the printer as the save to pdf option and selecting the destination via USB or even better skipping that dialog box all together and keeping it contained in the...

Can a macro be made for the following... The user will select cells in a row (like I3,J3,K3,N3,O3) but i will not know which row they will be selecting from and copy those values down 1 row Thanks for your help

Hi, I have created an Excel template with a ui ribbon where user can select the language for the template in a dropdown. The language selection changes all titles and sheetnames accordingly but is there a way to change the labels of the ribbon groups, buttons, etc. as well so that a user...

I've recently started having a problem selecting from drop down menus in the ribbon bar (changing Fill/Font colour etc). When I click on the bottom corner to expand the menu it only half comes up and won't let me select anything (see pic)...

The purpose is to select a month from data validation, and other cells populate future months. Then when selecting a different month those same cells change. Is there a way to capture multi months in different cells when a case is selected? Selecting Jan, D2=Feb,D3=Mar,D4=Apr Selecting Feb...

My code adds data to worksheet (“Members”) without selecting the worksheet. In order to sort the worksheet I have to select the ws and then select the range. Otherwise, the code sorts the active worksheet. How can I modify my code to sort worksheet ("Members”) without selecting it? Additionally...

Hi, I was looking to see if anyone knew a way to return a table of information by selecting single value from a drop down list. My issue is that the values in the table will be different with each single value so I am not sure how vlookup could work with that. Think of selecting one value from...

I have entered a data validiation condition in cell A1 with options "Yes" and "No". In cell B2 i want the outcome as follows: On selecting "Yes" option in A1, the value in cell B2 is automatically changed to 100% On selecting "No" option in A1, no change takes place in cell B2 and the user...

I have a workbook that has been "missing" column A for several months. I have tried all possible suggestions presented on prior threads here, done additional internet research, but have not been able to make the column reappear. I ultimately recreated it, but now that I have downtime before the...

Hi the code below is to type blah in cell a43 then hide rows 25 to 70 for sheets 1 to 5. it works only for sheet1 and then i get error message "selection method of range class failed" Sub fivesheets() For i = 1 To 5 ThisWorkbook.Worksheets(i).Range("a43").Value = "blah"...

Hey all, Can somebody spend a minute or so to fix my code that I cannot get working? I am trying to increase the flexibility of this code rather than just setting the range it will be based on my selection in the active sheet. Do I have to loop this each cell in the selection to get this...

Hello, Is there a way to close the userform from within my VBA code without selecting a button. I want this to happen without human interaction. Thank you

Hello, I have looked this up online and tried a few different things, but none have worked. It seems to be something many people have done in the past, but for some reason none of the solutions work for me. For example: Sheet2 A1 =Sheet1!A1 I need to fill down on Sheet2 Column A with...

Hi All, I want to clear contents of A1:F1 by selecting "Clear" from G1. G1 is a list "Select","Clear" So by selecting "Clear" from G1 would clear contents from A1:F1. And then by selecting "Clear" anywhere in column G would also clear the same row in columns A:F I'm trying to avoid creating...

Range("a2:a1000").Select For Each r In Selection If r.Value >0 Then r.Offset(0, 3) = Now() End If Next r I know theres probably a way without selecting, these sometimes run slow when making changes to a lot of cells

Hello, I've research this issue, but haven't found a simple explanation so I'm hoping someone can assist me. How do I paste filtered data from one column into another filtered column? No this is not as simple as selecting the "visible cells" in one column and then selecting paste in the...

Hi All, I have been sent excel sheets that have data values/items known to be present. But selecting the correct columns and doing Find just has does not work. Appreciate your help please.

Hello Hivemind, I’m coding a workbook that allows a user to select 3 files from an open file dialog box and have them automatically pasted and formatted to a prescribed reporting requirement. It works provided the files are sorted A to Z in the folder before the user selects them, but it...