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
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
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
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
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
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
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
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
May 24, 2007
If the selection (or any part of the selection) = bla bla bla
View 9 Replies
View Related
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
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
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
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
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
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
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
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
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
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
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
May 17, 2006
How do I get a message box to pop up when a certain cell is selected?
View 2 Replies
View Related
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
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
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
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
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
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
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
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
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