programming

Hi everyone. I'm thinking what book should i read regarding excel visual basic programming? like which author, i know everyone is good but some are hard to understand. if you have any suggestion kindly help me? :) i'd really like to excel in the world of excel programming. thanks alot!

Hello, I have an issue with a code in this excel file I have done from the past. Basically I have sheet 1 which is doing the deduction of cells in sheet 2 and sheet 3. i.e Sheet 1 = Pending Sheet 2 = Order, Sheet 3 =Deliver So cell Pending cell B3 in sheet 1 is the pending amount of the...

MrExcel. I hope he/she can help out on basic sensitivity analysis involving 4 variables: the thread (Very long macro") is still open & "quiet"! I hoped it wouldnt attract only one response of "extra question than an answer". Regards Patrick

Hi! I used the code below in a hidden worksheet so that if text is entered into a template and then deleted, the formulas will reappear. Sometimes, but not always, I receive the following error. Run-time error '-2147417848 (80010108)' Method 'Formula' of object 'Range failed This is the code...

Hello everyone, I am in need of your experts' assistance to teach me how to use the VBA program efficiently. Currently, I am trying to create a simple hydrograph with a specific condition: time of peak will be at the 1/4 of total time. My base data will be the USGS Dimensionless Unit...

So basically i have a graph with lots of different X values, but i'm trying to organize it in 0.1 intervals. Below is an example of my problem: This is an example of what i have: - X | Y - 0.1 | 2 - 0.12 | 4 - 0.25 | 8 - 0.34 | 4 - 0.43 | 6 - ... This is what i'm trying...

Thank you in advance for any suggestions. I have tried looking up SOLVER, GOAL SEEK, and most recently KNAPSACK. I'm not sure what is best., or if it is possible. There are 3 types: BASIC, SMART, and DEVICE In this particular group there are 17 BASICs 48 SMARTs 22 DEVICEs Now here's the...

Hi, I don't really know anything about programming or VBA, but I am trying to learn. Right now, I have a column that has data in it from a vlookup. I'd like to copy and paste this vlookup equation/code into the next column but change the range and one of the numbers for the whole column. I...

I have automated my spreadsheets to calculate based off of a Pivot table. As my data set goes updating, some columns in my pivot table are added or subtracted. In order for the automation that I have established to work properly, I need to add a (nonPivot) column off to the side as a numerical...

Can anybody help me edit? I want to copy from column to another workbook column using array. The range inside the array is the Alphabet of the column i want to copy/paste. The bold part is the one where I'm stuck at.. Sub setting2() Dim wb As ThisWorkbook Dim here As Workbook Dim there As...

Hi, I'm a newbie, an engineer assigned to do lots of re-bar detailing. I did it manually until now and seeking help to produce an excel program. Basically, most of parameters can be programmed using excel's common commands. However I have this question. How can I add a specific shape/picture to...

Design a simple guessing game, played by one player against the computer. When the program begins it will ask the user for their name, then welcome them to the Guessing Game, saying “Hello <name>, welcome to the CARD Guessing Game”. The game will then begin, displaying the players name and...

'This function generates a random number, and if it is equal to the 'lucky number' 'then it returns 'True', otherwise it returns 'False' Function getDiscount() 'generate randomNum between 1-10 inclusive 'If randomNum = LUCKYNUM Then: 'discount = True 'otherwise...

'This function is the starting point of the program. 'It welcomes the user, and asks which package they want (after displaying a menu of options). 'Once they enter a valid package it uses getQuantity to get the number of each type of ticket '(adult, child and concession) and then finds the total...

Hi all, Basically I'm trying to take information from a massive spread and based off of three colomns of criteria have the information in all rows that meets that be copied over to an existing sheet. However, I do not want all the information in each row from the master sheet to go into the...

Hey guys, I have been looking for a cubic b-spline vba code in which I can specify the knots on the curve. Does anyone have it available? Any help would be appreciated. I am striking out... Thanks.

Dearest pros , I'm having trouble with finding out how to do this in the manner i want it to work. I found some solutions of premade code that almost did the job but i can't seem to get the right code. WHAT I'M TRYING TO DO: -> We got an excel file with 2 different tabs. (clients and offers)...

I made a NBA power rating spreadsheet which uses each team's ranking in specific statistical categories from teamrankings.com. I'm wondering is it possible for me to somehow program my spreadsheet to automatically update the rankings from the web instead of me having to manually enter them...

Hi, I am using Excel 2010. I am attempting to write a macro that will open exactly 938 excel workbooks, copy the specified data, and then paste it into one master excel workbook. Most(99%) of the data in the 938 workbooks is in the same order. Once the relevant data is copied, I would like...

Hi! I would like to know if there's a way to make a cell change color depending on the value of another cell, i have minimum knowledge about conditional formatting but I'm guessing it can only be used to condition the cell with the value as as I'm trying to color a different cell than the one...