Investment Selection With Cell Selection

May 4, 2007

I'm trying to build an investment calculator. Tried searching "calculator" as keyword but return nothing similiar.

There are eight cell : [ A ][ B ][ C ][ D ][ E ][ F ][ G ][h]

[ H ] is price of the leverage

[A] is X balance
[b] is X lot size
[C] is X amount of money use to get x lot
[D] is X percentage of money use to get x lot
[E] is X point gain
[f] is X money gain
[G] is balance + money gain

Ignore the formulae for leverage to determine 1 lot price. Take 1 lot = 250.

What I'm looking for is when I enter any value at cell B, C or D, it will automatically calculate the value for either B, C or D cell.

Let say, the balance is 10000.

If I enter 2 at cell B. Then, it will calculate the value for cell C & D.

If I enter 750 at cell C, then it will calculate value for cell B & D.

If I enter 25 at cell D, it will calculate value for cell B & C.

how to use OR Selection in excel.

View 9 Replies


ADVERTISEMENT

Increment Cell On Selection And Lock/Protect From Re-Selection

Oct 3, 2006

I tried very hard to design a leave roster for user to mark their leave application. The criteria are as follows:

1. 4 applications per date
2. a region of worksheet (i.e. "A2 to H20) will be defined for users to "click" on the cells (within the defined region) to mark their application.
3. once a cell is clicked (i.e. marked), it cannot be altered.
4. each click will automatically increase the total by 1.

I got the following code to deal with the situation but user can still click on any cell outside the region (in fact I fail to define the region).

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim m
ad = Mid(ActiveCell.Address, 2, 1)
m = Range(ad & 24).Value 'here a formula "CountA(A2,A20)" will be place in the cell (24, c).......................

View 2 Replies View Related

Displaying Input Box Based On User Selection Of Dropdown Selection?

Jun 3, 2013

If a user selects certain options from a drop down list created by cell verification (from list), is it possible to display an input box and have the resulting input populate on another worksheet in the workbook? I have an attendance template I'm working with and if a user selects OT (Over Time) then a input box is displayed prompting for how many hours. The overtime is then tracked on another worksheet.

View 1 Replies View Related

Copy & Paste Selection Based On Combo Box Selection

Jan 30, 2007

I have attached a portion of an excel file I am using at the moment. What I require is a piece of VBA code which will allow me to copy selected data based on a combo box selection. What needs to happen is this :-

If the selection in the "Index" worksheet combo box related to "Month" in cell G19 is for instance "December", I would like the macro to compare this cell value to the cell values in cells C96, C124, C152, C180, C209, C236, C263 and C290 in the "Tech Services" worksheet and where the values match.......copy the commentary (Range C126:Z147 in December's case) to the range C34:Z55.

View 9 Replies View Related

Disable Selection In Listbox On Selection Of Item

Apr 4, 2013

I am working on a project where user has to select an item from a listbox, however there is a condition that if user select an item, other items of listbox should be disabled so that he/she can not select any other item.

Is there any way to do that as I tried

VB : Listbox.enabled = False
and
VB : Listbox.locket = True

in Listbox - Click/Change but no desirable results got.

View 1 Replies View Related

Restrict Drop-Down Selection Based On Selection From Another

Jul 20, 2007

I want to have a drop down list in a cell so that the value in the cell can be only selected from two columns of data. Additionally once the data from the first column has been selected I want to be able to limit the inputs the user can select from in the second column.

e.g. In cell C115 I want to have the value BDS05.

I want to be able to select the value BDS from a drop down list of values and once that value has been selected I want to be able select 05 from a list of values from 01 to 14
If I select BCS as the first value then I want the second set of values to be limited to 01 to 02 etc.

I have read about combo boxes and list boxes and I'm a bit confused about the best way to achieve this (or even if I can).

View 6 Replies View Related

Run Selection Change Event Only If The Row Selection Changes

Mar 26, 2007

I'm using the following code in a worksheet:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
col = ActiveCell.Column
Range("output") = ActiveCell.Offset(0, -(col - 4)).Value
End Sub

In case it's not obvious, the macro places the value in the active row and 4th column of the worksheet into the range "output".
The problem is, the worksheet is large and somewhat slow to recalculate. This macro forces a recalc on any selection change, but i only need it to run when the row selection changes, not the column.
I'm sure there's a straightforward way to reprogram this.

View 7 Replies View Related

Calculating Annual Return On Investment For Real Estate Investment?

May 5, 2012

What formula to use to show the Annual ROI for a real estate investment property (single family). I believe I have all my figures to calculate WITH (acquisition amount, annual net income, etc.) -- but I can't figure out how to determine the ROI.

Or - is determining that % even possible/logical?

View 3 Replies View Related

If Selection Or Any Part Of The Selection

May 24, 2007

If the selection (or any part of the selection) = bla bla bla

View 9 Replies View Related

Not Allow Cell Selection ...

Jun 16, 2009

It is actually a form - much like Access. I have protected it so it can't be changed. They can click on a particular cell, but as soon as they try to enter anything it gives them a message and entry is not allowed.

Is it possible to even prevent them from selecting an individual cell, i.e., restricting them to only clicking the control buttons ? I realize this is a spreadsheet, other products would probably have worked better, etc., however it's kind of like the last minor hurdle before releasing it for general use. The world certainly will not stop if I can't - just thought I would check with the expers.

View 4 Replies View Related

Last Cell In Selection

Dec 19, 2006

I would like assistance as to select a range where the end can be any cell.
The top of the range is fixed, but the bottom gets altered when you insert rows. I have used the "Selection.End(xlUp).Select" command. It does give me the end of the range that I need. How do I store this location if I need to select that Range? I need to keep this value as I need to select that range and print it.

View 6 Replies View Related

Date Selection In A Cell

Dec 30, 2009

Is it possible to click on a cell and a monthly calendar pops up for you to select a date to input? The output will be just the DD/MM/YY format.

View 10 Replies View Related

Protect Cell From Selection

Feb 20, 2010

I have a worksheet that has only 2 input cells. Everything else is display only. I know I can protect cells from being changed, but can I format a range of cells so that the user cannot even select the cell?

View 2 Replies View Related

Select Cell 2 Down From Selection

Oct 7, 2009

I have is is some code that ends up selecting a certain range, as an example A2:A60 but this could be any range (A2:A65, B2:B65 etc) what I need is a bit of code that selects the cell 2 rows down from the last cell in the selection.

so for the example above, if A2:A60 is selected, the bit of code after would select the cell A62.

View 2 Replies View Related

Limiting Cell Selection In VBA

Dec 5, 2009

I created a very simple user form to input some data into a spreadsheet. I have a list box and this is my button code to input the data to a cell.

View 6 Replies View Related

Multiple Cell Selection In VBA

Aug 21, 2013

I am putting together an order expediting sheet.

I get the code to refer to single cells, but cannot get it to refer to multiple cells in the same column.

The code i am using is:

Private Sub CommandButton1_Click()

If Sheets("Sheet1").Range("E6") > Sheets("Sheet1").Range("B2") + 3 Then Sheets("Sheet1").Range("F6") = "YES"
If Sheets("Sheet1").Range("G6") = "YES" Then Sheets("Sheet1").Range("F6").Clear
If Sheets("Sheet1").Range("F6") = "YES" Then Range("F6").Interior.Color = vbRed
End Sub

I need to have the ranges E6, F6, G6 to refer to E6 - E10000, F6 - F10000, G6 - G10000

View 5 Replies View Related

Selection From Dropdown Changes Another Cell

Nov 21, 2013

I have a a sheet with a drop down, if the selection of Critical in the drop down (A57) is selected, i need E57 to have a message saying we need to elaborate on the explanation or when critical is selected a popup with NEED TO ELABORATE in the description comes up.

View 1 Replies View Related

Cell Selection Over Given Range

Apr 8, 2014

I'm looking to go to every 8th cell in a column when I hit the enter key. I was thinking of selecting a small range say from A2 which is zero to A10 which would also be zero then A18 which is zero. The reason being I have a lot of figures to put in to each zero cell then I select "Series" to fill the cells in-between with the incremental figures between the two zeros which would be the difference between the two zero figures.

View 2 Replies View Related

Managing Cell Selection

Feb 11, 2008

I've seen a preference setting somewhere that allow me to specify what happens with the cursor after entering a new value in a cell. such as moving down or moving right or not moving at all?

How do I code the cursor to NOT MOVE out of the cell after a new value has been entered?

View 9 Replies View Related

Message Before Cell Selection

Sep 15, 2009

I am looking for VB Code / Formula which will does the following:

Before the Cell is selection; it will shows a message for guidance purpose; but the moment the same is selected; the Validation list which I prepared will appear.

For Eg: before the Cell is selected; it will show as"< select from drop-down list>"; but the moment cell is selcted; the normal validation list will appear.

I know that there is Input Message option in Validation List; but this appears only when the cell is selected. I am looking for message which will appear before the cell is selected.

View 9 Replies View Related

Message Box On Cell Selection

May 17, 2006

How do I get a message box to pop up when a certain cell is selected?

View 2 Replies View Related

Selection By Cell Properties

Aug 3, 2006

I am trying to write a macro to export a selection to a text file. I have the export to text file down, but can not figure out how to automate the selection. All of the cells that I want to select are the color "lime." The selection will start at B4 and run down to B?. These cells have conditional formatting that color them lime if the adjacent C column contains a "P."

View 2 Replies View Related

Sort On Cell Selection

Nov 14, 2006

I am trying to write a sorting macro using a selection change event, but am unable to apply the sorting to multiple columns. ie the code below will only re-sort an individual column upon activation of the macro, but I would like it to re-sort a full data range based on ascending / descending order of one column.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Target.EntireRow.Sort Key1:=Target, Order1:=xlAscending, Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
End Sub

View 6 Replies View Related

Subtotal Right Cell For X Selection

Apr 16, 2007

I wanted to know if there was a way to subtotal where a X is selected the right value in the cell. I have attached a sheet to show an example

View 9 Replies View Related

Lock Cell After Selection

May 8, 2007

Is it possible to lock the Cell after selecting the answer from list of that cell?
mean disable that cell from editing, deleting, and selecting another answer

View 2 Replies View Related

Prompt Upon Cell Selection

Apr 12, 2008

Which function would I use if I wanted a macro to run upon the user either clicking on a cell within a certain column, or tabbing to a certain column.

Right now I am using

Private Sub Worksheet_Change(ByVal Target As Range)
End Sub

But it doesn't take effect until after the user has inputted something into the cell.

View 3 Replies View Related

Unlock Sheet On Cell Selection?

Jul 4, 2014

I have a table and need to protect the sheet. From searching I see its a common problem as the table wont auto expand on a protected sheet.

I was thinking maybe I could create some sort of change event so if a user selects cells on Column A,B,G,H rows 13-1000 the sheet will auto unlock then lock again once they leave those cells.

I think it may need a few seconds delay to give table chance to autoexpand before sheet is locked again.

View 3 Replies View Related

How To Make Cell Selection Light Up Whole Row

Jun 30, 2009

Is there a way to light up a row when a cell in that row is selected?
I'm working within columns A through H.

View 5 Replies View Related

Auto Selection Of Cell In Macro

Jan 31, 2007

i am using user form to run some macro and i like that after running macro the cursor will return to the active cell , at the moment the cursor located on the user form.

View 9 Replies View Related

Run Macro On Selection Of Validated Cell

Mar 27, 2007

I have a macro that I am running "onentry" of a worksheet. The problem is that I have some cells that are validated to allow a list. If I manually type a word from the list in the validated cell the macro runs. However, if I make a selection from the list the macro does not run. I guess vba does not see my selection as an entry.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved