How To Force User To Fill In Three Of Four Available Cells

Sep 16, 2013

I'm trying to force the user to fill in three of the four available cells.

Initially they have a choice of filling in data for either:

Sheets(1).Range("C4")
or
Sheets(1).Range("C6")

But after that both Sheets(1).Range("C8") & Sheets(1).Range("C11") cells must also be filled in.

So it's either cells:-
C4 + C8 + C11
Or
C6 + C8 + C11

View 1 Replies


ADVERTISEMENT

Highlight Cells On A Form So That A User Knows Which Cells To Fill Out

Aug 13, 2009

1. I want to highlight cells on a form so that a user knows which cells to fill out.

2. When they print the form I do not want the cell shading to print.

View 2 Replies View Related

Force The User To Enable The Macro

Mar 4, 2009

I have Excel file that is linked to Access Database. Everytime the user opens the file, there is pop up message that warns the user we there to enable the macro or to disable it. I want to force the user to enable the macro or even better if I can make disappear this warning and automatically enable the macro. See attached for more details.

View 3 Replies View Related

To Force A User To Enter A Numeric Value

Mar 10, 2008

I'm trying to force a user to enter a numeric value, (one numeric value between 0 and 8, inclusive) into a range of cells, prior to exiting the spreadsheet.

The range would be D7:D252, and a single value would have to be entered into each range prior to exiting the spreadsheet.

View 9 Replies View Related

Force User Form Entry Only

Dec 30, 2007

I want to change data through a user form and disable users from going around my form. I want users to see the underlying spreadsheet as the form manipulates data.

If I enable a form in Modal mode users can bypass the form. If I use it without modal form I can't change data from my form. I seem to be in a catch 22.

View 5 Replies View Related

Force User To Enter Record First To Go Next Button

Dec 24, 2012

I have user form which allow user to entry their inputs in required boxes (Like TxtFirstName, TxtLastName etc.)

My form is working but which I want is that users should first fill up txtFirstName Text Box. Otherwise we will not able to do edit his/ her name in the last Name Text Box (TxtLastName).

Is there any way to do that?

View 1 Replies View Related

Force User To Choose From 2 Drop-Downs

Dec 29, 2006

I have two columns, Account Number and Account Type. I already use Data Validation on Account Number to make sure it is numeric and on Account Type to make sure the user picks from a drop-down list. I want it so that if a user inputs an account number, it forces the user to automatically pick from the drop-down menu in the account type column, otherwise post an error.

View 3 Replies View Related

Force User To Select A Listbox Item

Jun 9, 2007

I am attempting to use an if statement to stop a user from trying to input a listbox as a null value. The if then statement is not working. The listbox value is null but the if statement doesn't react.

If listbox1.Value = Null Then
MsgBox "you must select a serial number"

Exit Sub

End If

View 3 Replies View Related

Force User Onto Next Cell Once Character Limit Reached?

Feb 10, 2011

Currently using LEN to simply count 50 characters then it tells the user that they need to move onto the next line.

Is it possible with VBA that after 50 characters reached in the selected cell it forces the user into the next cell below and so on in a loop?

View 7 Replies View Related

Force User To Enter (Year End) Or (Qrt) Using Inputbox Method

Oct 31, 2011

I need to force users to enter one of these words only (Year End) or (Qrt) using inputbox method.

Note that user must not leave the inputbox until he/she enter one of these words.

View 1 Replies View Related

Force User To Enable Macros - Issue With Activating Specific Sheet Afterwards...

Aug 4, 2009

I am utilizing the following code to force the user of my database to enable macros. This is the

View 4 Replies View Related

Force Focus Back: Pop Up A Userform To Provide Instructions And Collect Some Additional Data From The User

Feb 18, 2009

I'm working on a spreadhseet which has several macros that can take up to 5 minutes to run. When the macro(s) complete, I pop up a userform to provide instructions and collect some additional data from the user.

The "problem" is that when the user moves to another application to do other work, the user form remains hidden behind the active app. I've added some text to the status bar to let the users know the processing is done, but they would like something more obvious - so, is there any way I can force focus back to Excel?

View 2 Replies View Related

Fill Value In A Cell Based On User Entry

Mar 26, 2009

I have a dilemma.

1.I want to be able to a have a cell be filled with a certain value when the user enter data in Column C.

2.I know that this can be accomplished by a formula, but my spreadsheet will work my efficiently with a macro.

3.I do not know much about VBA but I believe that I will need a macro for each sheet that fills in the word.

View 6 Replies View Related

Fill Combobox Dependent On User Logon

Mar 2, 2012

I have a logon screen and would like to fill a combobox dependent on which user logon.

If User1 logon - options 1,2,4 must be in dropdown list
if User2 logon - options 2,5,6, must be in dropdown list, etc....

View 5 Replies View Related

How Can I Create A Pop Up User Fill In Form Using Vba Coding

Jun 8, 2009

Is it possible to use vba coding to create a pop up user form by clicking on a button in excel?

I want to create a pop up form that a user can fill out with fields for name and address information. Then click a button to save and close the form based on the last name field box.

View 9 Replies View Related

Fill Listbox Or Combobox On User Form `

Jul 4, 2007

I have been able to create a userform that allows users to fill out a form without the need to navigate throught the excel spreadsheet form that has been created. to further refine this I am trying to use either a list box or Combobox to display specific items for certain cells, ie Travel Method (Air / Rail / Other), or Department (Projects / Finance / Engineering / Admin etc). I can create these in a spreadsheet without to much problem, but sofar have been unable to get them to work in the user form.

View 2 Replies View Related

Prompt User For Text To Fill Column

Dec 16, 2007

- Prompt User for Text String
- Fill in Column B from B2 to B(LastRow of ColumnA) with the Text String

For example if

Column A

Ant
cat
Dog

and the user enters the text string "Animal"

then Column B will look like

Column B

Animal
Animal
Animal

The number of rows in Column A vary across my excel sheets.

View 6 Replies View Related

How To Insist User To Fill In Cell With A Value For Data Validation

Oct 4, 2012

I have a file where I need the user to fill in a value in a single cell (A1) in order for the data validation I have set up in column B to work. Can I set up a second data validation in the cells in column B? Or is there a way to enter a data validation in cell B11 that would error the user if A1 is not filled in, and circle the cell (A1) that they need to fill in? B11 currently returns the sum of B3:B10.

A
B

1
Straight

2
Time

3
Sun

4
Mon

5
Tues

6
Wed

7
Thurs

8
Fri

9
Sat

10
Sun

11
Total Overtime

View 8 Replies View Related

Auto-Fill Data Based On User Input

Dec 22, 2009

Excel 2003, I have a list of products with corresponding prices located on a hidden worksheet. I have a spot on another worksheet where users can select a certain product and next to that cell there is a column for price. What I want excel to do is auto-populate the price cell based on what product the user selects. For instance, if the user selects OD2000N, then I want the price to auto-populate with the corresponding price that is found on the hidden sheet. Like I said before, I know this has probably been answered, maybe even mulitple times but I can't seem to find the appropriate thread.

View 9 Replies View Related

User Form: Automatically Fill The Dates To Which They Are On Holiday

Jul 5, 2006

I am making a holiday form with names down the page and dates along the top, what I am trying to do is create a user form so it will automatically fill the dates to which they are on holiday. What I would like the code to say to find the cell at a specific date (column) and person (row) so it will enter a custom text or number.
The data that is submitted on the user form would be a start date and end date and the person’s name.

View 6 Replies View Related

Exl2K User: Sheet Is Password Protected But User Can Change Color In Unlock Cells

Jun 16, 2006

find attached zip file . if you open the file then you can understand the problem.

I need to change cells color and text color as per user choice in Password protected sheet : (user is useing excl2000)

Kindly open attahced file i putted the note inside the file.

View 3 Replies View Related

Can I Fill Non-adjacent Cells With The Fill Feature? (example Listed)

Nov 7, 2008

how to enter data in non-adjacent cells using a fill command.

Here is what I am trying to do:
in the column, I am holding ctrl button to select every 10th cell down the sheet. I need to enter a date in every selected cell that is exactly 7 days apart, i.e., 11/7/08 then 11/14/08 then 11/21/08, etc.... but no other dates or data.

I have tried to figure out a way to do this other than manually, but am confounded.

View 9 Replies View Related

Force Tab Order Of Cells

Jan 1, 2008

I have input cells on a protected sheet with a tab order array setup. It was originally set up to work when their was a Worksheet Change. Not every cell is going to have data input into it. This is where the problem lies. If a cell is left blank it tabs out of sequence. I changed it to a Worksheet Open Sub but that didn't work.

Code is as follows: ...

View 9 Replies View Related

Force Entry In Multiple Cells

Jan 16, 2009

I have a spreadsheet in which has many different cells that need to be completed if another cell has data.

Examples

If the user inputs a name into A3, they must complete cells B3 thru D3. Cells B3:D3 contain different entry methods including a drop down list.

On the same sheet, if the user chooses GTD from a drop down list in cell U3, cells BA:BJ must be completed. And if they choose GCI from the drop down list in U3, they must complete cells BK:BR

View 9 Replies View Related

Force Text To Uppercase In Active Cells

Jan 28, 2009

To ensure correct data entry, I need to ensure that the filled cells in a column are always in Uppercase for example, irrespective of whether they are typed in upper or lower case.

I have found the following code, which seems to work quite well, even though I have the impression that it slowed my workbook down slightly.

View 14 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

Force Cells To Recalculate (simulate Double Click)

May 4, 2007

I have an interesting question for everybody here. Let me see how to best explain it.

I start in the code making sure column Action Plan completion has a value in it. Copying in the issue modified column if neccesary.

'Back fill last modified
'I need to start with the first data row (3) and the action plan completion column
Let intcurrentrow = 3
Let intcurrentcol = intactionplancompletion
Do Until intcurrentrow > intmaxrow
If Cells(intcurrentrow, intcurrentcol).Value = "" Then
Let Cells(intcurrentrow, intcurrentcol).Value = Cells(intcurrentrow, intissuemodified).Value
'Need to ensure that everything is formatted as a date
Let Cells(intcurrentrow, intcurrentcol).NumberFormat = "m/d/yy h:mm AM/PM"
End If
Let intcurrentrow = intcurrentrow + 1
Loop

Later, I place this formula in a given cell.

=If(I9="Open-Remediated",M9-K9, If(I9="Closed-Remediated and Validated",M9-K9,"" ))

The info I copied above is placed into the column K.

When I run the macro, the cell formula outputs "#value".

However, if I go double-click then enter the cell calculates just fine.

I've tried excels overall recalculate function, but that doesn't change this.

Does anybody know how to simulate a double-click on a cell?

View 6 Replies View Related

Asymmetric Fill (fill Out Column B Referencing Column A, But Only Incrementing By 1 Row In A Every 2 Cells In B)

Feb 1, 2010

Is there some easy way to fill out column B referencing column A, but only incrementing by 1 row in A every 2 cells in B?

Example:

Column A:
A1 = 1
A2 = 2
A3 = 3
etc...

Column B (I would like to fill this, referencing column A):
B1 = A1
B2 empty
B3 = A2
B4 empty
B5 = A3
etc

View 4 Replies View Related

Fill Date Across Columns Based On User Date Range Input?

Mar 5, 2014

based on user date ranges entered on sheet1, I'm trying to write code that will write each month of the date range on other sheets across the 2nd row. at this point I'm getting "object required" error at "Set DateStart = Cells(2, 6)"

I also want the date format to be mmm-yy (Mar 14) on the sheets even if sheet1 has a different format. I tried using sourcerange instead of DateStart, but that didnt work either.

Code:

Dim projStartDate As Date
Dim projEndDate As Date
Dim DateStart As Date[code]....

View 1 Replies View Related

Excel 2010 :: Color Fill A Range Of Cells If Specific Cells Not Blank

Feb 7, 2013

I am using Excel 2010 and basically i am trying to fill a range of cell with a green color if any value was enter in a specific cells. Example: I would like to fill range: A10:c13 with a green color (regardless of the cells content in this range) if a value was entered in cell C10 or C11 or C12 or C13.

I've tried conditional formatting but unfortunately I'll have to apply formatting for every cell and for a range of over hundred cells is not efficient.

View 7 Replies View Related







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