excel & vba 2007

Hello everyone, I want to perform the following function Like i have a value on my Base price text box i.e 2500 I have a value in my Tax amount i.e 2% Now i want my Total textbox to print the value of ((2500 + (2500*2/100)) How do i do it..? Please Help I tried something but its now happening...

Hello everyone! This is my first post! :) and I already did some research but I couldn't find any formula or module that could completely solve this problem. The numbers to letters was already solved, but the twist is really difficult.. I need the numbers in cell A1 to become coded letters in...

I am checking out a project developed in Excel 2010 for use in Excel 2007 on a client's computer. To try to avoid referring to any of my own macros in Personal.xlsb or a UDF.library, I have installed Excel 2007 in the Virtual XP machine running under Windows 7. I have with difficulty got the...

I need to split dates along with their respective duration. example: Begin Date | End Date |Duration 3-Nov 5-Nov 2.5 **I need it to look like this in excel:** 3-Nov | 1 4-Nov | 1 5-Nov | 0.5 I need the half day to be...

I have a list. Item number in Rows and Stores in Cloumns. In the Column I have the number of units related to the Item number for each door. I would like to create VBA code that will copy Item# (ColumnA) and paste it in front of each Store Column. So it should look like Item#:Store A: Item#...

Hi all, Having trouble on these few methods. I'm new to excel so guy i need your help. I have a list of different product items example: Marigold Orange Juice Marigold Apple Juice Sunkist Orange Juice Sunkist Apple Juice Tropicana Orange Juice Tropicana Apple Juice All of these i have...

Hi - I am looking to create a record log in Excel 07 by scanning in various barcodes with one of the scans triggering an auto entry of current date in column A and a constant data in column F. Seven columns total with indefinite amount of rows. My current setup: I can scan six columns with...

Hi All, I am stuck on something and I am hoping that someone can help me out. I want to be able to select the cell where this macro will start. IE: Change the Range("C1").select to a user select by clicking a cell? I am not sure how to go about it. What this macro does is it selects a range of...

Hi all, This is my 1st post here and I come in the hope one of you, Excel guru guys (or girl) can make sense of this! I've got this rather ugly code running on Excel 2007 and there it can go through 60.000 rows in less than 2 minutes. Try it on Excel 2013 and bang, it takes FOREVER... to the...

Can someone please help me to create a drop-down list using VBA in Excel 2007? I want to have a drop-down list of values (7 in total, 2 words each). Once the particular value is selected the macro writes a value category (3 categories, 2 words each) into a specific cell as well as the value...

Hey Guys, Please solve : I have workbook name "Dashboard" and "Not Require" and save on same location. Now Dashboard workbook is only active and I have to do below with using Macro : 1. Fist I have to open "Not Require" workbook. 2. I will make vlookup in Dashboard workbook on column A from...