chosen

Hi All, My issue is that I get a error message "The file you have chosen is in use. Please close the file before you import". I am in Diagram View, go to existing connections and double click the source file that is an xls, file saved on the share point. My goal is to import a new column I...

I have a spreadsheet where column “H” has dates in format dd.mm.yyyy (examples 31.12.2017). The number of rows and the dates in column “H” varies each time I run the code. I need a code that will look through all the dates in column “H” and summarize them for each month of a chosen year and...

Hi all The help so far has been great I’ve got another quick enquiry I want to get my sales sheet to do a calculation based on whether the option Yes is chosen from a drop down menu For example If I enter the amount of £1200 into a cell and then in the tracker the option Yes is chosen from a...

I would like to use the values declared in the Enum section and get the names of those variables. Private Enum Bks [_First] = 0 English = 0 Maths = 1 Science = 2 [_Last] = 2 End Enum Dim MyBooks(2) As Boolean Private Sub cmdEnumTrial_Click() Dim ChosenBooks As String Dim Runr As...

Hi all, Im Ray I Have a Question todo with Piviot & VBA (Excel 2007) is it Possable to read the Chosen Filters in a Pivot Table, and write them to a given Cell? All Help appreacheated Ray :confused:

Hi forum! Trying to copy the active sheet to the workbook chosen by the user - but having trouble with how to define the new workbook. Sub ssss() Dim myfile As Variant Application.DisplayAlerts = False Application.CopyObjectsWithCells = False ActiveSheet.Copy With...

Hello I am just wondering if it possible to populate the listbox depending on what has been chosen for the combobox and if so, how would you go about doing it? Thanks