visual basic help

  1. D

    Insert Microsoft user's name into cell

    Is there a code or formula I can put in place that will enter the Microsoft user's name or email, who is in the excel sheet, in column N when text is entered in column A?
  2. R

    Generating auto year in VB

    Hi I am creating a VB form, which updates a spreadsheet, and as part of this creates a unique reference number. I want the Ref number to be CUST/YY/unique number I am struggling to get the year automatically, I have tried a couple of ways but it didnt work. Currently I am using the below...
  3. K

    return a value of '1' if the lowest value amoung the two cell is green

    Please do you know how to formulate the following condition in excel; when you have two cells one with high and the other with low value and one of the cell is colored green. so you want to return a value of '1' if the lowest value amoung the two cell is green color and '0' is the highest value...
  4. J

    VB Macro Help Needed - Exporting a Range to .txt with save name as cell value

    Objective: I want to export a known range of Cells to a .txt file with the click of a command button. I want the file to be automatically saved with the name as the value of a cell (A12) I already did some research and was able to slightly change an existing code I found that someone created to...
  5. C

    VBA for vlookup that returns source formatting

    Hi I'm a complete newbie to VBA and struggling to find a google answer that fits my specific needs and lack of knowledge. I have 2 workbooks; One called 'Master' that contains a unique code in column A and a long text description with bold, coloured text and colour shading (not conditional...
  6. E

    Multiple remove in VBA

    Hi, I am trying to run something that will remove the entire row if a series of letters are present. I am using the below code. It works, but I need to add in around another 25 letter combinations (i.e at the moment it removes EZY, but I also need to remove EX, EFT etc etc.) Can anyone...
  7. V

    Copy rows to other sheets in the same workbook depending on a condition in one column.

    <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo; min-height: 13.0px}p.p3 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo; color: #011993}span.s1 {color: #011993}span.s2 {color: #000000}</style>Hi, I...
  8. J

    SOAP 1.2 in VBA

    Hi there, I am relatively new to both VBA and very new to SOAP. I have an online shop which I would like to be able to download orders from through excel. I have been given the following SOAP code by the online shop but have no idea where i go now - i'm sure it's relatively simple but don't...
  9. N

    Runtime Error 1004

    I'm a novice at VBA and am using the immediate window. I am getting a Run-Time error '1004': Application-defined or object-defined error and I don't know why. I have the following code in my immediate window. I have a similar code, but for the Income Statement which works just fine. I...
  10. D

    Calling

    Hi Gurus, :-D This is my first post so if I'm not playing by the rules, I'm happy to take on any feedback... So I have a code that I use frequently that I want to place in my "personal macro workbook" so I can call it quickly without re-writing it each time I wish to use it. The code...
  11. J

    Scrolling Count?

    Hello Everyone, I'm sort've new to Excel and writing code in VBA. I have the following situation: my company tries to make revenue predictions at its many sites (740 sites). We are the midst of creating a forecast method and we'd like to compare the old one to the new one. So currently I have a...
  12. C

    Visual Basic for Excel

    I have a series of swipe card "beeps" in excel 2010 for the month of april. They are sorted by date per each employee. There are multiple "beeps" per day since the employees go from the production floor to the cafeteria, home, or to the restroom I need to device a macro where I can calculate...
  13. M

    Date picker on a specific cell Excel 2010

    Hi I'm trying to add a date picker to a sheet that will run when a user selects a cell in column A. I got as far as being able to run it any where on my workbook but I am having problems containing it to column A nor can I figure out how to make the date picker appear when I select a cell in...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top