vba 2007

I upgraded to windows 10 today and I thought I may like it until I tried running my programmes coded in Excel 2007 VBA. First of all I found I could not save a file to C:\ for some reason VBA was trying to add a random number after c:\ After changing the path to users\documents I then tried...

Hi, I have a sheet of around 450 rows, I would like a macro to do some manual work for me. Is it possible for a macro to insert one blank row if a "No" is present in column T. If possible I would like the row to be inserted above the “No”. Thanks

I need to be able to have my combobox become visible once a number value is placed in a textbox on a userform. Here is where the textbox gets its data from: Private Sub UserForm_Initialize() Dim Cell As Range Dim Rng As Range With ActiveSheet Set Rng =...

In my macro, I am creating textboxes and spinbuttons in the code, and have created a class to allow me to deal with events. I have the following declarations inside my class: Public WithEvents SpinButton1 As MSForms.SpinButton Public WithEvents IntegerTextBox As MSForms.TextBox For some...

I am a beginner to VBA and looking for some experts help here. I am basically looking at writing VBA code to do multiple filter and provide final results. I have following data in my Main Sheet Date Week CalendarRun14-Oct 1 Run114-Oct 1 Run214-Oct 1 Run314-Oct 2...

Can some please assist me with the following: I've tried a bunch of code which has somewhat helped but can't seem to get what I'm looking for. Note: Each Row specified is Actually its own sheet with the same header. Sheet1, Sheet2, Sheet3, Sheet4, & Sheet5 Expected Outcome: Name -...

Hello everyone. I want cells to be automatically be locked, based on a value of another cell. If there is no attendance: Lock cells 'test score, result, re-test score and re-test result'. If there is attendance: Unlock cells 'test score, result, re-test score and re-test result'. BUT: If the...

Hello Everyone, I am very to new to VBA and have run into some difficulties early on. Currently I have a tabs "IDB_CapEx", "IDB_OpEx", and "RCM". The RCM contains a variable number of columns with the row information as follows: Row 2: Project Name Row 3: Project Number Row 4: Project Manager...

Hello! I am new to programming in excel but am looking to make a VBA that allows me to see if a value entered exists in a second spread sheet. If it does then write a comment next to it. If not then write a different comment. This is what my spread sheet currently looks like: Sheet1 contains...

Hi guys, I am a newbie in excel and vba. Apology in advance if the question look so stupid. I have read through some of the post but I could not find the answer I want. I am now working on an excel spreadsheet which will automatically update every day so that one row will be added on the top...

Hi, After looking up this amazing forum website for answers, I decided to post a question because I do not understand excel vba all the way.. So I have values in Column L3 to AH3 and I would like to use if condition to see which values are less than 10. I also have other rows where this...

I have an Excel 2007 spreadsheet with 2250 rows and 19 columns. In these rows, I may have two rows of duplicate customer information that need to be combined. I may also have rows of customer data that are not in need of combining. A unique customer member number can be used to identify the rows...

Hello all,I'm trying to write a VBA code that will allow me to reference column A, then find the all cells that have no data inputted. After this I want to delete said row(s). The issue that I am running into is because the data that I am using has been copied from another sheet referred to as...

I have problem in making this. format in a text file Note: The text is only on A1, separated by a delimiter indicator which is "^" https://docs.google.com/file/d/0B_eArBbGfxv4OTJ2YTlDaFBnZDA/edit?usp=sharing To this . . . after text file multiple import to excel As you can see in the image...

<tbody> I'm working on small project in which I need to add sheets to the currently open workbook from any external database of worksheets in another workbook. I made a form to import any sheet that is required in the currently open (active) workbook. The sheets will be copied from remote...

hi, i'm starting at VBA and what i want to do is to load the files into a listbox (excel files, already done) and then when an specific workbook is selected i want to grab/copy a sheet called "Yield" from the selected sheet and paste it into my workbook. (MainMenu_c) So i have the following...

It seems there is a problem copying from one excel applications worksheet to another excel applications worksheet through vba. I am opening two excel applications (not the same instance) and am trying to copy a single range of just values no formats and I keep getting errors. I have narrowed it...

Hello All, I have been trying to make the performance of my VBA code go faster as I am trying to complete a simple operation in a short period of time. I am trying to link one worksheet in a workbook to another worksheet in another workbook with only the data that I care about. So far...

Hello All, First time posting here so hello :D I am having a problem with scrolling through each object in a for each loop. Code: Function detectDateRange(xlsRemoteApp As Excel.Application, xlsRemoteWB As Excel.Workbook, xlsRemoteSheet As Excel.Worksheet, strSheetName As String) Dim...

Hi there I'm trying to create a Dynamic Range within a recorded Macro by editing the VBA that's already there. I've searched around but none of the tutorials seem to fit my needs. Am confused as to whether I need an 'offset' or DIM or End(xlUp) function and how to use it. I simply need to...