vba & excel 2007

Hello i am a very VBA newbie and i wonder if it is possible to select multiple cells that contains more than 0? ( Range("A1").Value > 0) and if its not move to the next cell until it find the cell have value more than 1 can i ask what kind of statement and function that i must learn? Thank...

I recently found a solution to display date in Graph on userform from John Walkenbach. I was curious and really want to add a feature to be able to change the divison value in x axis or Y axis. If for example the divison is 0-10, and if I want to increase the divison from 0-10 to 0-20, then...

Hi there! I am currently working on a project where I would like a macro to go through a "trial and error" process to find a best fit solution with a few constraints. I am new to vba and would love some help, even if it's just where to start. The project I am working on has 4 unknowns counts...

The above I posted a while back. Seems this can't be done in a formula. I know a bit of VBA, but doing what we want in VBA is not my strongsuit. If anyone can assist to acomplish above story in VBA I would be greatfull. The color part is the most needed for now, but the check would also be...

Hi there, First of sorry for my poor English. Am no native speaking and writing person. Thx in advance for any assistance. I am forced to make this in Excel 2007, so it has to work in that. I have to adjust a sheet that is used to store the expected hours on a project. People fill in their...

I have a userform where once i keyin the part no(textbox1),description(textbox 2) and supplier(Textbox3) will auto populate. And when i click the update button after keyin Date(textbox4) & Quantity(textbox5) the data's will be updated in worksheet4. For example the data's will be updated in cell...

Hi I'm struggling to sort a 'sheet' of Data. The sheet is a direct 'copy' of the master data (therefore Cell A2 in this sheet (sheet2) is {+sheet1:a2} etc, as I do not wish to auto sort the master data. <tbody> A B C D E 1 PRODUCT UNIT TOTAL 2 N 2 Becks -5 -15 3 Y 2 Budweiser 4 12...

Hello, very new to VBA, mid-level at excel. This is my first project and i need help. I have two sheets, one name TEMP and the other HUM. They contain climate data, mean temperatures per month for every state and HUM contain Humidity values. <tbody> Mean T. Jan Feb Mar Apr May Jun Jul Aug Sep...

Hello guys, I'm new to the forum and not particularily well versed in VBA so please bear with me. I'm making a scenario analysis of costs for different investments. I'm comparing the as-is (current) situation with several scenarios. I start with a sheet called "as-is" and then create...

Hi I apologise if this has already been solved somewhere on this forum, however I am unable to find it. I have two workbooks in which I am trying to use the same code. In one it is working but in the other it is not. I am using Excel 2007. Here is the code: Option Explicit ' Developed by...

Dear all, I have a excel file with some deadlines and tasks. What i'm looking for is a vba code or formula to alert me which task is available for the day, when i arrive to the office. Also, I'm trying to, in some tasks, send a email with the fields "To", "Cc", "Subject" and "Text/message body"...

Hi, i want to do the following, from the table below i want to: 1-Filter per column C for unique values 2-Once filtered if its only "1" row, then put each cell on that row into a variable. 3-Once filtered if the results is more than 1 records, meaning the same email address has 2 or more...

Hi All, I'm very new in writing VBA. Please help me in activating already open workbook. Following is the code i'm using but don't know how to complete it. Please help. Sub AssessmentDataPaste() Dim MyPath As String MyPath = Sheets("Main").Range("C7").Value ' Pop-up a...

I have a table that tracks a bunch of info such as, person, category, department, description, due date, and priority. I have, at best, extremely weak VBA skills, so I REALLY need help. Here is what I'd like to do, if it's even possible. I would like to have a VBA code that will...

Hi folks, I have a table to track Personal, sick, vacation and half days taken for 25 to 150 students. They are recorded by placing an "S", "P", "V", or an "H" in the cells for the corresponding date. There is a different tab for each month. School year July 1 2016 to June 30 2017. I would...

I writing a VBA varinat array to Excel, I have a date column in the array formatted UK date. When I write it to Excel it is in US format. I do the same thing on a diferent sheet and it works fine. Even if I change the format of the cells after writing in the array the format does not change...

Hello all, I am attempting to have my userform enter data into certain cells on my spreadsheet. I need it to enter the data from a text box into a cell. The cell that it goes into depends on the data selected from a list box. So if in the list box I select the option of "8605", and in the text...

Hi, Would anyone be able to help me set up a second and third tab for the master spreadsheet listed below? I want the second tab to only list the parishes in Store Category 'A' and the third tab to only list parishes in Store Category 'B'. I tried using a formula like the one listed below...

Hello all, File_Name = SK & "-" & Year & Month & Day & "-" & Daily_Drawing_Number & " BOM" & Rev_Letter & ".xlsx" Application.Dialogs(xlDialogSaveAs).Show (File_Name) I am trying to force this to input the specified file name into the dialogue box for the save as box. However it...

I recently had to replace my hard drive and in the process I ended up going from Excel 2010 to Excel 2007. The script has been working fine previously but now it has stopped. I have checked the Trust Centre settings to make sure macros will run. I have also checked ?Application.EnableEvents and...