vba 2010

At the time a file is opened, I'd like an input box to pop up that states, "This Tract Is:" and the editable text in the input box (the white box) is referenced from a cell in the just opened workbook - always cell A1. Then the user can edit any text he needs to, press "okay" and the file will...

Hi Everyone, i'm new here :) i made a research on internet and this is what is mentioned to be the best Excel forum available. So here I am asking for an advise from some experienced user. So let's meet the point of this thread.. I need to create a Macro (I'm using Office 2010 Professional +...

I am new to MrExcel, but have gotten ALL my issues resolved simply by searching threads, however this one !@# *This has been migrated from EXCEL to MSO ACCESS 2010 I have a database that uses the days of the week for its field names. Each row has similar data. Row 1 has the same data as Row 2...

Hello, I am very new to VBA and any help would be appreciated. The purpose of this code is to reformat one pivot table upon a change on the same worksheet only. I have placed the code in the individual worksheet object. It works perfectly EXCEPT when I refresh a pivot table on a separate sheet...

Hi! i'm trying to find Error #REF but i didn't manage it to work. and i don't know what is it i'm missing? here the code Dim ws As Worksheet Dim R As Range Dim sCell As Variant For Each ws In ThisWorkbook.Worksheets Set R = ws.UsedRange For Each sCell In R...

Hi, I recently found an awesome userform made my Roy Cox. "Database Form" What im trying to accomplish is to have on listbox display dataset from a sheet (so far so good). However as there are more than 10 columns of data i soon discovered the limit when using additem. Ive since realized that...

Using Windows 7 Office Excel 2010 I'm trying to add a reverse order for the axis for a chart that populates based on various data. Because of this, some (NOT ALL) of the charts need to have the reverse order = False. I have tried adding the statement (.Axes(xlValue).ReversePlotOrder =...

Hi, I have an Excel-2010 file which contains students unique admission number in column-A. Everytime I click in any cell in column-A, the code below finds the student in the PDF file. Need help with the following: Everytime I click on a cell in column-A, it should find the student admission...

hi! i wonder if ther some how i can check if the start of the string is 0 and remove it så it start with a number insted. somthing like this 016.00123.000 006.00071.000 162.00003.000 012.00065.000 009.00012.000 224.00001.000 to 16.00123.000 6.00071.000 162.00003.000 12.00065.000...

VBA - Create New Worksheet from list I need some excel 2012 VBA help please. Table2 in the worksheet named "Index" has employee information. The code below reads the list and creates a new worksheet and renames it based on contents in column e and increments to the next This code works for new...

Hi, Could you please help me with a VBA code that would look at column M in sheet 1 and if any cells in column M =>10,000,000 then this entire row gets copied on another worksheet. Thanks so much for your help. Ambarish

Hi.... I'm running Excel 2010. I need to create a Userform using VBA (which I can do OK), but I'd like it to be called something other than "Userform1" The following code extract works ONCE only:- (and I have "Microsoft Visual Basic for Applications Extensibility 5.3" and "Microsoft Forms 2.0...

Hi! In programming there is alot of code and your can solved a problem with many ways. I'm new in vba and when i programming i'm always wonder. what should i use and what should i not use in programming so the program not taking so much performance and memory. So what is good in programming and...

Hi i'm trying to resize a label so the label get exactly same size as plot area. but it get bigger than it is. :( sub test() Dim sPoint As Point Dim ch As ChartObject Set ch = ActiveChart.Parent Set sPoint = Selection With Label1 .Left = ch.Chart.PlotArea.Left...

Hi I need to save single sheet from workbook (sheet7) as text file in specific folder (c:\Test) if the file exists a warning should show if you would like to over-write the file. And et the end change file extension from .txt to .dat Thanks Zibi

Hi I need to save Sheet7 in active workbook to folder "test" on my C: drive as .txt file and check if the file exists prior to overrite. Please help.

Hi! I need a mackro that take out a point in a chart and show the value of it. For example, in a chart, there are several point and when i click on the point it shows the value of it (just for that point). thx in advance

Hello everyone. trying to write a code to substract the row A:F from each row of I:N and the corresponding results for each one on P:U I ask vba code instead of formula because I have to do this so many times a week. and my list in I:N is more or less I2:N500. any hand on this welcome. looking...

i wonder is there possible to not using .copy but still get the value from range and put it to another range and still got same text alignt, text size, font bolt?

Hi! i'm trying to creat a macro that add new rows base on date. evertime i hit ctrl+shift+A it will add new row to column A and B. and Column A will get this days of date. and if it go to next month Column A,B,C and D will get new row as well. A get the days date. and Column C got the days...