Allow To Users To Enter A Cell In The Worksheet

Jan 26, 2009

Function Dice(DiOne, DiTwo) As Double
Dim sum As Integer
Dim DiOne, DiTwo As Integer
Dim Odds As Double
DiSum = DiOne + DiTwo

Select Case sum
Case Is = 2
Odds = 1 / 36
Case Is = 3
Odds = 1 / 36
Case Is = 4
Odds = 2 / 36
Case Is = 5
Odds = 2 / 36
Case Is = 6
Odds = 3 / 36
Case Is = 7
Odds = 2 / 36
Case Is = 8
Odds = 3 / 36
Case Is = 9
Odds = 2 / 36
Case Is = 10
Odds = 2 / 36
Case Is = 11
Odds = 1 / 36
Case Else
Odds = 1 / 36
End Select

Dice = Odds

End Function

I'm trying to allow users to enter a cell in the worksheet and type =dice(number, number) and it calculate the probability of that amount coming from two rolls of a dice...

I'd like people to be able to use this just as though it was the SUM or VLOOKUP functions....

View 9 Replies


ADVERTISEMENT

Macro For Users To Enter IP Address?

Apr 7, 2014

I want to use it to get data from snmp and put it in excel cell. I managed to do this with this macro:

[Code] .....

Now I want to be able to change the IP address. For example in cell A4 to fill the IP. And the IP to change in the macro. So this macro to be use for different hosts.

I place a button for this macro and when I press it a cmd windows is popping for 1 second and hide. How can I make it not to show at all.

View 1 Replies View Related

MonthView Control Can Be Set To Allow Users To Select Multiple Ranges And Enter Different Dates

Dec 4, 2013

If MonthView control can be set to allow users to select multiple ranges and enter different dates into those ranges? I know I was able to do with with the previous Datepicker control and I thought it was as easy as setting the Show Modal property to true.

View 1 Replies View Related

Prompt Users To Enter Information In Specific Range Of Cells Before Save

Mar 11, 2014

Is there a way to prompt users to enter information in a specific range of cells before they save?

View 1 Replies View Related

Use One Template To Enter Data With Users Being Able To Start Entry From A Number Of Different Starting Points

Jul 30, 2009

We're trying to use one template to enter data with users being able to start entry from a number of different starting points. this changes they way the look-ups have to work. The attached sample explains it a whole lot better.

View 2 Replies View Related

Data Validation Dropdown Menu But At Same Time Allowing Users To Enter Free Text

Nov 15, 2010

Is there a way to have a data validation drop down menu but at the same time allowing users to enter free text as well.

View 3 Replies View Related

Allow Users To Insert / Delete Rows On A Protected Worksheet?

Apr 5, 2014

I have a worksheet that I have some "locked" cells on. I also have protected the worksheet but when I check to allow users to insert rows and to delete rows and then save it, when I re-open it I can't insert rows or delete rows???

I am using some VBA to allow for the collapseing of rows while maintaining protection and that works perfectly. I want users to be able to insert and delete rows while maintaining protection. I thought a simple check in the protection was good enough, but for some reason it isn't.

View 2 Replies View Related

Excel 2007 :: Login System For Two Users On Worksheet

Mar 7, 2014

I am creating a login system for two users on a excel worksheet. I have the two users on a drop-down list, Maria and Andrew, which then requires a password entry. This is linked onto a data validation to make sure that the password matches the data table.

After, I then click on a macro, which, when successful, takes me from sheet 1 to sheet 2.

My problem is that I need to have it so that Maria is taken from Sheet 1 to Sheet 2, and Andrew from Sheet 1 to Sheet 3.

View 1 Replies View Related

Select Next Control / Cell On Worksheet After Enter In Control

Jan 9, 2008

Within the ComboBox properties, is there anyway to control after "enter" his hit, you move to the right instead of down (similar to the edit under Tools/Options)?

View 9 Replies View Related

Reprogram Enter Key On Worksheet Activate

Aug 31, 2009

Is there code for worksheet activate event that will reprogram the Enter Key to mimic the Tab Key such that if you hit Enter, the cell to the right of the active cell is selected? I've searched the net for several hours today and find nothing that addresses this question.

Also, the Enter Key would have to be normalized on worksheet deactivate.

View 10 Replies View Related

Userform To Enter Data On Worksheet

Sep 14, 2006

I have sheet (say Sheet3) that is in essence a Database. I need to create a Userform to insert a row above the highlighted cell and insert the data on the Userform in that row.

Userform would have 3 textboxes to enter data, a submit button and a cancel button. (the 3 boxes titled Part, Price,Vendor)

In the Worksheet the 3 Columns are
A C E
Part Price Vendor

View 6 Replies View Related

Force Enter Data In 5 Separate Cells In Worksheet

Jul 24, 2014

I am trying to force users to enter data in 5 separate cells in a worksheet. I have tried editing code I have found here, but just can't get it to work.

It is in the second sheet of the workbook and the sheet is called Invoice - the cells I want to force entry into (and the message I need) are as follows.

J2 - You must enter the salesperson's name
J4 - You must enter the customers name
J5 - You must enter the customer's address
J6 - You must enter the customer's postcode
L2 - You must enter the Invoice number

View 5 Replies View Related

Calendar Control To Enter Chosen Month As Worksheet

Jul 17, 2009

I have a worksheet that has a Calendar on a worksheet from Calendar Control 8.0.

I want to be able to pick a month from the calendar and press a button to convert the selected month into a worksheet. I have a custom made calendar worksheet that I would like for it to be converted into.

I have uploaded my workbook. It contains the custom calendar worksheet as well as the calendar control.

The file is called "calendar.xls".

View 9 Replies View Related

Enter A Value In A Textbox, Search For It In An Worksheet, And Populate Other Textboxes With Adjacent Values If The Value Is Found

Jul 14, 2007

I want to enter a value in a textbox, search for it in an worksheet, and populate other textboxes with adjacent values if the value is found. Anyway, the problem is that if the value is not found, I get a debug error.

Dim test1
test1 = TextBox1.Value
Worksheets("data1").Activate
Find_Range(test1, Cells, xlFormulas, xlWhole).Select
TextBox2 = ActiveCell.Value
TextBox3 = ActiveCell.Offset(0, 1).Value

I'm sure there's far better code to do what I need, but I tried to keep it simple. With the above code, it only works if the value is found. If it's not, I get an error. So how do I make it so that if the value is not found, the value of the textbox2 is "Not Found" or something...

View 3 Replies View Related

Unprotected Cell Will Not Allow Users To Highlight

May 28, 2009

I have certain cells that are unprotected but still will not allow the user to highlight "Fill" the cell. The can only edit or type in the cell.

How can I allow a unprotected cell to also be filled with color by a user on a protected worksheet?

View 2 Replies View Related

Allow Users To Fill In Only Particular Ranges Of Cell

Feb 19, 2008

I'm not an Excel expert and I'm wondering whether to protect an Excel workbook in order to allow users to modify only specific cells in the sheets.

Also, each user should modify only his related sheet whitout permission to modify the ones created for the other users.

View 9 Replies View Related

Enter 4 Columns Of Data In Row Then Shift After Hitting Enter?

Jun 1, 2014

I really know nothing about vba so here goes. I would like to enter data in a row with 4 cells of info. then hit enter and return to the first cell and move the row down. all four cells must have data entered. and all four must move down. i tried some code as below i found and i modified but it did not work as expected. this moved the row down when returning the cursor to A2. It also should not copy the data style of the top row.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column <> 1 Then Exit Sub
Application.EnableEvents = False

[Code].....

View 4 Replies View Related

Formula Must Be Confirmed With CTRL+SHIFT+ENTER Not Just ENTER

Aug 15, 2008

This formula must be confirmed with CTRL+SHIFT+ENTER not just ENTER. You will see { } brackets appear.

View 3 Replies View Related

Stop Users From Selecting Another Cell Until Current Selection Receives Data

Jul 21, 2009

Amongst the several sheets contained in my workbook, there is one called 'Inspection Report'. Users fill in whatever data is required in the other sheets, and once they get to this one, they are supposed to enter a number from 1 to 3 into Cell X1 (which is currently selected) before they select anything else. Unfortunately, I am currently unable to stop them from doing what they should not be doing.

So, I would like to have a notification of some sort pop up into their face if they click or move the selection anywhere else while Cell X1 is still empty. Something like a validation would be nice.

View 6 Replies View Related

Automatically Enter Text In Cell When Due Date In Other Cell Is Exceeded By 272 Days

May 29, 2013

I want to enter the word 'Closed' in cell B1 when the due date in cell A1 is exceeded by 272 days. I have tried using conditional formatting and excel accepts the formula but nothing seems to happen. Here is what I have tried;

B1=IF(A1<=NOW()-272,"Closed")

View 4 Replies View Related

Go Immediately To A Particular Cell After Inputting Data In Another Cell And Hitting Enter Options

Feb 20, 2010

I'm inputting data in E3 and after I hit enter I want B2 to be
selected. But only for E3 and only in one worksheet. And possibly a
further step... Sometimes the formula in B2 has picked up data from
another place depending on what value was entered in E3. If it's done
this then I won't need to go to B2, I'd want to go to A8 after E3
instead of B2.

View 9 Replies View Related

When A Date Entered On A Specific Cell, Automatically Enter A Text In Other Cell

Jul 10, 2006

I have 6 Headings in excel named...

"A" in cell A1, B in B1, "C" in C1, "D" in D1, "E" in E1 and "F" in F1.

There are two projects.

Project 1 has phase A, D & F and Project 2 has phase A, B, C, D & E.

My Specification follows...

1). Take Prject 1 - Which starts from A...in cell A2 I will keyin "A". When the phase comes to an end I will key in the end date of the phase. As soon as I key in the end date in cell A2 Letter D should automatically appear in the cell D2 and when Phase D comes to an end I will key in the end date in Cell D2 which should automatically keyin F in the cell F2. and is the same case for Project 2.

View 3 Replies View Related

Automatically Copy Formula To Next Cell When I Enter Something In Perticular Cell

Sep 8, 2007

Automatically copy formula to next cell when i enter something in perticular cell ....

View 11 Replies View Related

Cell Date Formatting: Cell To Display Mm/dd/yyyy And Enter Mm/dd/yy

Aug 13, 2008

I have Excel 2000, recently when I format a cell to display mm/dd/yyyy and enter mm/dd/yy, it is displaying dd/mm/yyyy. Or it starts out correctly and during a future opening of file it displays incorrectly.

View 2 Replies View Related

Automatically Enter Text In Cell Based On Another Cell?

Jul 29, 2013

I am trying to enter a value in a cell which is dependent on a corresponding value in a table. I have a table A which has a cab type and a corresponding cab number.

What I want to achieve is that when I enter the cab number in another table say in cell (D3), the cab type is automatically entered in cell (C3).

Table A
Cab Type
Cab No

Indigo
100

Indigo
758

Innova
1544

Indica
1675

View 1 Replies View Related

Copy Formula From Previous Cell To Next Cell When I Enter Something

Sep 9, 2007

I want to copy formula from previous row to next cell when i enter something in perticular cell.
i.e

--Colomn A --- Colomn B -- --------Colomn C
1 01-09-07 ----- John ----------=vlookup(b2,$s$1:$t$10,2,false)
2 01-09-07 ----- Smith -------- =vlookup(b3,$s$1:$t$10,2,false)
3
4
5

Now if i enter date in cell A3 then cell C3 should be automatically filled/copy formula as celll C2. and so on......
then if i enter data to A4 then cell C4 should be automatically filled/copy formula from cell C3.

I have also attached example file.

View 9 Replies View Related

Highlighting Cell When Enter Specific Date In Another Cell

Jul 4, 2013

I have a problem regarding highlighting a specific cell, when i entered a specific date in another cell

Let me explain

If there is a Name, joining date, termination date/resignation date in cell A1 A2 & A3 respectively.

If the name is John, Joining date = 01/01/2012, Resignation Date 06/06/13

I need a formula which highlights the cell A2 plus all those cells which have the same date when i entered a date (i.e 01/01/2012) in another cell.

View 2 Replies View Related

Automatically Enter Text In Cell Based On Another Cell

Jul 28, 2013

I am trying to enter a value in a cell which is dependent on a corresponding value in a table. I have a table A which has a cab type and a corresponding cab number. What I want to achieve is that when I enter the cab number in another table say in cell (D3), the cab type is automatically entered in cell (C3).

Table A
Cab Type
Cab No

[Code].....

View 7 Replies View Related

Cell = Then Enter

Aug 3, 2006

Is there a way of a message being displayed if a cell has a specific value.

e.g. if cell A1 = 2 then a message is displayed to say 1 more and action will be taken.

View 5 Replies View Related

Enter Date Without Day In Cell

Jul 31, 2014

I have to enter a ton of dates in cells that don't need to include the day. And so was hoping if there was a way to enter a date into a cell without having to enter the day.

In essence, it seems like I have to type in the date as month/day/year and excel will figure it out from there. I would like to be able to just type month/year without bothering with the day, such as 9/14. And then excel recognizes this as a date.

Excel has to be able to recognize it as a date because these dates are expiration dates. And I would like to conditional format these dates so that when the expiration date has past the cell turns yellow.

View 10 Replies View Related







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