select

Hello, This is the 1st time I am working with OLAP Cube Pivots. Need help please. I have a OLAP Cube pivot that has years from 1900 to current year. However it is missing few years in between. I need to be able to select all the years except for the last 15 years (2004 to 2019 needs to be...

Hi, I have a user that logs into OneStream and gets all his data in Excel but he has several files, but I need to refresh all these files through a macro. The problem is how to I do this? I tried the following macro but it doesn't work: For Each cnct In ThisWorkbook.Connections Select case...

Hi all, Hope you're having a good day. I want to create a popup for a user to choose between three options Select a file, Select a folder, Cancel I made a userform to handle this. If they choose to select the first option, I want to use Application.FileDialog(msoFileDialogFilePicker) to...

hi I am looking for a way to select a column to the last row of data. The problem is that the column I want to select has data only in row 1, but the sheet has data all the way down to row 633. I am using a Mac and have tried using all the standard keyboard shortcuts and also using the function...

Hi ya'll - realizing this isn't an Excel question but hoping someone could help me interpret the output of the following SQL query and how it is structured. Here is some information about the database: - conversations_conversation records represent a single conversation between two people...

Morning, Please could you check my code & advise a fix. I open my workbook. It defaults to INCOME (1) to open first. I see the msgbox asking me to select MONTH & YEAR I choose to select CLOSE FORM The form quickly coses then reopens. I choose to select CLOSE FORM again & it closes. Now i can do...

Hello gang! Quick question hopefully with a simple answer. Why would I get a FALSE in a cell that I set = to ""? This is in a Select Case statement. TIA

Hi all, I'm declaring my source as "src" and my discount as "dis" src will always be a value, but dis can either be a value or blank. An example will be src = NQS and dis = "", or src = NQS and dis = NQS20 My code is below: src = Cells(ActiveCell.Row, "F").Valuedis =...

Hello, I came across this code which changes the Font color for individual names within a Range. How can i also include the functionality to change the font Name, Style Size and Boldness for each individually? Thanks for any help! Sub Change_FontColor() Set MyPlage = Range("NamesList")...

Hi I want to select let say 100 cells A1:A100. I can do that using mouse but I wonder of I can select A1 and then go to A100 and they are all selected. I select A1 and I can go to A100 using F5 and type A100 but that would jump to A100 without highlighting the range A1:A100. Thank you.

I am looking for vba code to select all cells to the right of the active cell(s) (include active cells) and insert a copy below. Must include all conditional formatting. Thanks

Good morning. I am working on the same spreadsheet described in this thread (https://www.mrexcel.com/forum/excel-questions/1112241-hiding-rows-using-vba-multiple-criteria.html) It is a sheet where based on the answers provided in a set of dropdown boxes, certain rows need to be hidden...

has anybody got a snippet of code to make a combobox auto complete? as the user types in a name into the cbo, i would like them to be able to select from a list that drops down below the combobox.

Hi all, I have three (3) button in a Group: Group Name: Sorting Button Names: FirstNameSortButton LastNameSortButton LocationSortButton Since a ComboBox cannot show more than 1 column when the "ComboBox1_Change()" event fires, I had to overlay a 2 column ListBox on top of my ComboBox so all...

Hi I want to improve the code below. I am thinking if it is possible to display file browser for the user to choose file from. Like when you click open in Excel, a file browser will be opened to help users to select a file. Can I do that here? Thank you very much Sub wbs_open() Dim xfile...

Hi All, I am new to SQL but learning quickly. I have a spread sheet that has on tab linked to an external SQL database an several other tabs with static data When I run the following "select * from linked" (this I the linked sql data) I get no results, however if I do "select * from...

Hi All, I need help with a Select Case in my code. I'm new to VBA and have never used the Select Case function. With my online research, I found some examples, but none is really giving me the information that I need. When the user call a UserForm (frmResource) from any one of the sheets Monday...

Hello, I would like to print attached sheet with frozen panes (two rows + five columns) on one A4 as follows. I have set print titles according to instructions on this page. https://excel.tips.net/T002702_Printing_Just_the_Visible_Data.html Afterthat I select range F3:AC10 and then print...

Hello folks Stumped again.... :( I want to find and select a cell via VBA based on a text value picked from a userform combobox. The target value will be a text value in a single column which will NOT be sorted and may contain blanks. Is that doable at all? Thanks

Hi, I am new user. And i need help. I need a multiple selection VBA code for my work. For example: SheetX SheetY SheetZ SheetA I only need to select: SheetX and SheetZ. How should i write VBA Code for this? I have nearly 450 sheets and will wrote the code for them. Thanks a lot and have a...