Hello everyone,

I just learnt how to use VBA, I'm beginner!
I try for 2 days to do something and id still doesn't work so I think I need some help... I don't understand what is wrong with my code.

I'm sorry I couldn't attach the excel document but it's too big so I took photos...
and here are some explanations of what I'd like to obtain :

I have two sheets:

-sheet 1 : data source
-sheet 2 : Graphics related to these data sources

Boths of the sheets are a 12x12 matrix, for which each element is a column of 180 values (it's a result as function of the angle)

I am trying to put together a macro that will insert multiple images into a 3 column table of a new Word document. The images themselves are from a website URL, the URL which is concatenation of a URL and the data in column A.

Row 1 of my workbook is all headings. The URL I am using is "http://qrcode.kaywa.com/img.php?s=8&d=" with the value of Column A, starting at A2 and working its way down (to the last value).

As an example, A2 contains the data 1-85858, so the URL image will be http://qrcode.kaywa.com/img.php?s=8&d=1-85858.

Hi Everyone!
My name is J.R. and I'm a novice to VBA. I've dabbled with code off and on, but I'm very interested in learning new things that would help my efficiency and productivity. With that said, I'm having some issues with a spreadsheet that I've been task with completing.

Let me explain a few more details associated with the task.

Sheet 1= "Overview_Cost Summary"

Dear experts,
I've started an project in Africa to disinfect the ground with overheated steam. This means less risk of failure by growing there food.
This steam is heated by sun radiation. I’ve made a model in Excel and I want to calculate the amount of heating energy that can make the steam.
In this model I use one unknown factor and can solve this problem by using the solver.

Hi, I run various VBA simulations within Excel. My question is as follows: I noticed that some process managers allow the reprioritizing of processes, e.g. “IObit Process Manager”. The default priority for an Excel instance is “Normal”. If I change this to a higher priority (“Above Normal”, “High”, “Realtime”) what benefit if any can I expect. Thanks.

This file I prepare specially to show what I am looking for.
The parameters in this file are different then one describe in my first post "Excel 2003 - "IF" function", but
the problem is the same.

This function - IF(C10=$BX$5,$BO$4,"")....... is written in cells BX10:BX500.......
and work correctly in single row, but every time the new row start, for sample: .....IF(C11=$BX$5,$BO$4,"")
data in previous cell BX in that case BX10 disappear.

It is possible to create formula that prevent that??

Please he

Thank you very much

For example:
On cell A1 01/01/2011
On cell B1 01/04/2011
On cell C1 it should display "Less" if day difference is less than 90 days otherwise it should display "More"
Thanks in Advance!

Hi

I need I macro that can move data from a registration sheet into a summary sheet, and place the data in the right date row in the summary sheet, considering the date of registration (in cell B8 in the registration sheet). Pleace see attached example. Also I want the macro to see if there is data in the cells in summary sheet before overwriting it (if there was data there already). I.e. if the summary sheet already holds data in the actual date row I want to get a worning before the old data is overwritten.

Please can any of you help.

Thanks Knut

ive got an xls i use for project tracking and invoiceing.
looking to get it to compare an entered date to a date range
and if that is true then add #'s.

any help guidance?

Loki

Hi, i have created a DLL with C#, it calls a Stored Procedure in SQL Server.

I have tested the code in the DLL in an C# Aplication, and works fine, the problem is that i created a function in Excel to call that DLL, the code is like this:

Function SALIDASALMACEN(ByVal subalmacen As String, ByVal depto As String, ByVal familia As String, ByVal datei As String, ByVal datef As String) As Double
Dim myObj
Set myObj = CreateObject("Almacen.Salidas")

Hello everyone,

first off, thanks for the opportunity to be a part of the forum.

Here's my story.

In Excel-file, I have a column with terms all written with low case letters. I'd like to have them all beginning with an upper case letter.
Since there are terms consisting of 1, 2 or more words, the function =large2 doesn't solve the task, because only the first word should begin with a capital letter!

I'd appreciate your suggestions.

I have 2 excel files.

1-Master which contains the UserForm1
2-Slave which has some codes.

The form opens the slave, then hides the form ("me.hide") to allow working with the slave.
After the slave file is been done working with, I activate a procedure in the Slave which should call the Master, unhide the UserForm and update some fields:

[code]RUN "Master.xls!ShowUF(field1,field2)"[\code]

In the Master I have the ShowUF macro who looks like this:
[code]
Sub ShowUF1(field1 As String, field2 As String)
UserForm1.Label1 = field1
UserForm1.Label2 = field2

I am fairly new with VBA. I have created a document which, when completed, allows the user to click on a button and email the whole document to me. That works fine.

I want to modify it and am getting lost.
What I want is:
A list box which has the names of four different people in it.
The user clicks on one, two, three, or all four of those listed names to highlight them. If they click on a name a second time, it unhighlights that name.

Here is my dylema:
I want to build a form which uses another file to do certain changes. In this form the user has to fill-in the exact address of a certain cell from the external file.
What I want is: Instead of the user typing: cell "A2" from sheet "alpha" from workbook "wk1", The user to browse for the file (already done), and just by clicking that cell, to fill the form with that cell's address.
basically:
1. open file
2. add an onclick event of some kind.
3. confirmation textbox "Are you sure this is the correct address?" (loop until "yes")

Hi,

Iam creating a tool to compare the contents present in the two word files are same including the Font, Font style and the Font Size between the two MS word documents. I need a vba code to create this tool. Kindly request you to provide the code and help me in creating the tool successfully.

Thanks,

Jayanth J

In my Laptop installed version of Ms-office 2007, every opening of Ms-excel,
once "PERSONAL.XLS" also opening with excel file. please help me how to
deactivate my normal excel file..

Hi Guys/Girls

I am trying to assign %'s for a Property Holding Cost. I cannot formulate the correct IF statements to correctly calculate the below-mentioned equation (See attached document).

1 2 3 4 5 6 7 8 9 10 Time Period (Months)
10% 20% 30% 40% 50% 60% 70% 80% 90% 100% Cumulative Cost % assignment
10% 10% 10% 10% 10% 10% 10% 10% 10% 10% Spread Cost % assignment

The cost needs to be paid quarterly, i.e. month cost % 1,2&3 are totaled in Month 3(i.e. 30%). When the property is sold, the remaining 10th month holding cost is totaled to finalize the Sale (i.e. 10%).

Hi All,

I am trying to auto fill the cell value of a column based on previous two columns for that i have a formula as..

= INDEX(Sheet2!$D$2:$D$102, MATCH(1, (Sheet2!$A$2:$A$102 = $A2) * (Sheet2!$B$2:$B$102 = $B2) .....

The value is updating but when i am trying to retrieve this value from java using apache poi i m getting formula of that particular cell instead of its valu how to get the auto fill value...plz help its urgent..

I have the entire layout done, I just need a great deal of help in making my coding correct so I can make it run properly. I have included all the steps needed in order to complete it and want to make sure I'm headed in somewhat of the right direction but I am struggling greatly. Any help would much appreciated.

Design and code a project to calcu¬late the amount due for rentals.
Movies may be in VCR (videotape) format or DVD format
Videotapes rent for $1.80 each and DVD’s rent for $2.50.
New releases are $3 for DVD and $2 for videotape.

See attached file for one example of a solution. It uses data validation (list), Vlookup for the answer and Worksheet event code for the messagebox.

Hello,

I'm completely new in the forum, and also quite new to VBA.

I work in HR and have a list of job functions that I need to map according to a table containing financial data. Eg.:

HR job function = Construction
Finance data = 142
HR Job function = Marketing
Finance data = 143

Now, I want to create an input box where my user chose from a drop down list the HR job function. Once the HR job function selected, the corresponding Finance data info should appear in a MSGbox. The mapping of HR job functions and Finance data is all stored in an excel file.

Hi again,
I have another question concerning an Excel Spreadsheet.

I want to count the members of each organization after the change. I assume I must get the sum of each org out of column A for those that do have "no change" in column B, plus the sum of that org in column B.

The Example is attached.

Thank you much for helping me out.
This forum is awesome and I'll recommend the website!

Hi Friends,

Iam quiet new to VBA programming,requesting for help

Iam performing simple math calculation using VBA prog

CTN QNTY CTN OUT CTN AVAILABLE
30 5 25

CTNAVAILABLE= CTNOUT - CTNQNTY

I want to implement a constraint
if ctnout is greater than equals ctqnty then
make ctnqnty=0 and ctn out=0.

currently am implementing the following code

Public CellCopy As Variant

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("L:L")) Is Nothing Then Exit Sub
Application.EnableEvents = False

Hello there and thanks for reading my post!
I would like to find out the percentages of people that changed organization, manager or role in an Excel spreadsheet.
I hope to create formulas that show the changes in percent and update when the information is edited. I am currently interning for a company and would like to be hired full time, and you could help a lot!!
I attached a sample worksheet (the actual data is confidential of course).

Thanks for reading my post!
Julia

Hi;

I work with FM 11 and FM pro advanced server. My abjectif is to export word file from a database server ,after running a macro script from default excel file.
I cretae the macro that save data sheet excel on a template word . I shoud make it running on a database server ( FileMaker server 11). Is it possible to run an excel macro and save documents (.doc) on the DataBase server??

My macro is:

Dim TimeToRun
Sub Auto_Open()
Call scheduleJb
End Sub
Sub scheduleJb()
TimeToRun = Now + TimeValue("00:00:01")
Application.OnTime TimeToRun, "MacroAutoJB"
End Sub

Martin

attached is a test file.. at the moment it just collates data from 53 onboard timesheets. - This is just for test and development

I'd appreciate if you'd just check and see if if it's heading in the right direction.

There are 2 command buttons on the red tabbed Master sheet. one to collate the data, the other to empty it.

Scenario:
I've got 20 employees who everyday register their working hours into certain categories. As you can see in the file attached every staff member has got 53 sheets in their workbook. One for every week in the year and a finally a total sum of the weeks.

Challenge:
What I need is a total of totals. Meaning i need to find way in which i can gather every staff-total into a new workbook where every staff members working hours are summed. It needs to be dynamic so that staff member a can type in his working hours and immediately after 'the total of the totals' are updated.

Demonstration of a crossword style game using userforms. Note that all data for the game is embedded within the userform making it very easy to import/export into other workbooks. This modular style of programming allows us to create a bunch of standard userform utilities and mix n match them into larger projects.