Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
create a prompt box to perform a function?
I am trying to have a prompt that comes out that allows users to change a row
of numbers but a percentage that they want or a colum. Meaning right now I have e-k with rates in it. They want to be able to change the rates without having to go in on a daily basis and calcuate each rate seperately and then enter that new rate on the sheet. They want to be prompted to say this row change by +/- a given percentage. I can not figure out how to get excel to do this. I have working on this for days and have come up with no easy solution at all. Please help me! Cathy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
create a prompt box to perform a function?
Cathy,
Does this help? Private Sub Worksheet_selectionChange(ByVal Target As Range) Dim nRate Dim cell As Range On Error GoTo ws_exit: Application.EnableEvents = False If Target.Column = 1 Then With Target nRate = InputBox("Supply rate") If nRate < "" Then If IsNumeric(nRate) Then For Each cell In Me.Range("E" & .Row).Resize(1, Me.Cells(.Row, Columns.Count).End(xlToLeft).Column - 4) cell.Value = cell.Value * (1 + nRate) Next cell End If End If End With End If ws_exit: Application.EnableEvents = True End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH RP (remove nothere from the email address if mailing direct) "Cathy" wrote in message ... I am trying to have a prompt that comes out that allows users to change a row of numbers but a percentage that they want or a colum. Meaning right now I have e-k with rates in it. They want to be able to change the rates without having to go in on a daily basis and calcuate each rate seperately and then enter that new rate on the sheet. They want to be prompted to say this row change by +/- a given percentage. I can not figure out how to get excel to do this. I have working on this for days and have come up with no easy solution at all. Please help me! Cathy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a prompt box? | Setting up and Configuration of Excel | |||
How do I create a prompt box? | Setting up and Configuration of Excel | |||
I cannot perform this function PLEASE HELP! | Excel Worksheet Functions | |||
perform 1 function, stop, perform different function | Excel Discussion (Misc queries) | |||
How to perform the following function in Excel? | Excel Worksheet Functions |