Inputting Check Box (ie. Yes / No)

Aug 4, 2008

I have a question to ask, and not sure what you would call it. I am looking to input a 'Check Box' into a cell so you could have for example... two (2) choices - Yes - No - you would have an empty circle in front of each, and you select the one (1) you wish which would make it filled.

Is there a way to do this in excel? If there is, could someone possibly turn me in the right direction (or assistance) with inputting this?

View 9 Replies


ADVERTISEMENT

Inputting & Collecting Data

Dec 17, 2009

I've just been asked to do a new Quality Control project for my boss. What I'm looking to do is be able to input the thickness values of our product in one worksheet, and have it recorded in another, as well as have the data separated by the model number

The main problem I'm having is figuring out how to enter data in the 1 worksheet as a template, and have the data consecutively stored, one after the other

Are there any functions that will allow me to do this?

View 6 Replies View Related

Inputting Formulas Into Cells Using VBA

Dec 28, 2007

way to 'insert' a formula into a specific range of cells using VBA only when the Value of $A$7 is changed to a value that does NOT equal "Custom".

Heres what I have so far using Worksheet change event....

View 10 Replies View Related

Inputting Dependant On Cell

Oct 12, 2008

on sheet1 which is called working sheet and cell d25 is asking what type of goods been sold

i have several different sorts"

ie
s25
s28
s50
s69
s70
s82
abd
t70
t140

i want the spreadsheet to look up somewhere on a sheet called delivery all the components that could be used for that type

so i guess i need to name define?

ie if s25 is selected

on delivery sheet in a20 it would then list all the components underneath each other.

View 14 Replies View Related

Inputting Pictures Into UserForm

May 6, 2009

I discovered this sample database sheet (attached) on the forum I wanted to ask if a picture can be linked included? i.e. when entering a new record a picture (stored in a directory) can be added and linked to that record. Then when reviewing the records the picture is then displayed.

View 6 Replies View Related

Display The Day By Inputting The Date?

Feb 20, 2007

for example.

I type "20 Feb 07", and excel formatting auto changes that to "Tuesday 20 Feb 07"

I actualy need this for a more complex formula...

if A1= any date from monday to sunday of one week, then A2= mondays date+21

the only way i can comprehend this is to make a formula that says if A1= a monday A2=date+21, A1= a tuesday A2=date+20, etc.

View 13 Replies View Related

Inputting Information To Appear In Another Cell?

Feb 4, 2012

How to input information into one cell and it appears in another cell based on specific information inputted.

View 3 Replies View Related

Inputting Parameters For Deletion Of Row In VBA?

Aug 28, 2013

I have some code that works fine below. It deletes an entire row based on the value in column J.

Ideally I would like to give the user the option to choose which column to base the deletion on. i.e. some kind of drop down box or input parameter where they could choose a different column "A", "B", "C" etc...

Private Sub CommandButton1_Click()
'Removes values less than 0
Dim rng As Range, cell As Range, del As Range
Set rng = Intersect(Range("J1:J1000"), ActiveSheet.UsedRange)
For Each cell In rng
If (cell.Value)

View 1 Replies View Related

Inputting Fixed Time

Jan 23, 2008

I have a sheet with a number of different columns, is there a way that when data is input into a cell in the first column that it time stamps the last column on the same row, and this time stamp is fixed. Then when data is input into the cell below the same thing happens, so i can have a time stamp for each entry.

View 9 Replies View Related

Inputting Sequential Numbers From One Cell

Nov 28, 2008

I am trying to make excel list in a column like 1,2,3,4,5. this is dependant on a value i place in one cell eg 5

i want excel to then place 1,2,3,4,5 in seperate cells down a column. does this make sense.

then the calculations will only appear the the numbered cells.

View 14 Replies View Related

Create A Chart By Inputting A Date Range?

Dec 5, 2008

I have a worksheet with 500 rows. Coulmn A is all the dates of the items. Is it possible to somehow havea userform or something that I input a start date and a finish date and it only shows me that info.?

View 2 Replies View Related

Calculator Compute Automatically After Inputting The Date

Apr 29, 2009

i m making a very small calculator. It's a little hard to describe, but I need to look like the following
Let's say the individual got here on 1 Jan

Phase 1 is for days 1-14 last for 14 days
Phase 2 is for Day 15-35 last for 21 days
Phase 3 is day 36+

This is what I need it to look like: All the phase information will compute automatically after inputting the date arrived. In addition I would also like to be able to change one of the phase dates and the remainder of the phases compensate according to the newly entered date.

Date Arrived = 01 Jan 09
Phase 1 = 01jan09
Phase 2 = 04Feb09
Phase 3 = 05 Feb09

View 10 Replies View Related

Existing UDF For Returns Correlation (inputting Price)

Jul 18, 2013

Any existing UDF that will take two ranges of Prices (for stocks) but get their respective returns to then get the correlation of that?

View 4 Replies View Related

Vba Calculator: Click Add After Inputting The Digits Just To Have It Added To He Variable, Which I Just Add Up At The End

Jan 29, 2007

i have 1 - 9 number buttons, the +, - , * , / , and a C for clear, as well as an exit button. the display is a label. i have to click add after inputting the digits just to have it added to he variable, which i just add up at the end... terrible.

Option Compare Database
Option Explicit
Dim var1 As String
Dim var2 As String
Dim first As String
Dim second As String
Dim sign As String
' on load
Private Sub form_load()
Form.Caption = "this calculator lab sucks."
Me.lbDisplay.Caption = ""
End Sub
' on clear
Private Sub cmdClear_Click()
Me.lbDisplay.Caption = ""
var1 = ""
var2 = ""
End Sub.............

View 3 Replies View Related

Automatically Changing Color Of Cell Within Half An Hour Of Inputting

Jan 9, 2013

I want to create a macro or formula for changing the colour of the cell after half an hour of inputting.

View 3 Replies View Related

Macro Code To Get Saturday And Sunday Dates On Inputting Year

Jan 16, 2014

I am looking for Macro code preferably to get list of dates with Saturday / Sunday in a separate columns which falls Saturday and Sunday on imputing the year.

View 5 Replies View Related

Excel 2007 :: Dragging And Inputting Cells Into Numerical Order

Mar 25, 2014

Excel 2007. At the bottom of a column of data I'm trying to reference the cell $AG4. There are 340 total columns. Each additional column to the right needs to reference the next cell in column AG. So I'm trying to drag and copy horizontally from $AG4 to $AG340. When I try just the single column it just copies $AG4 into everything to the right. When I have to columns ($AG4 and $AG5) and grab both to try to copy horizontally the numbers increasing it just does $AG4, $AG5, $AG4, $AG5, etc.

View 2 Replies View Related

Inputting Number Representing Time Spent On Task Under Drop Menu

Dec 8, 2013

Is it possible to create a drop down menu where additional information can be added then tallied up in a separate table?

I would like to create a menu representing "tasks" where an amount of "time" can be designated per menu for my employees to select and fill. I would like this information to then be tallied elsewhere so I can keep track of our efficiency.

I've attached the excel file to give a better idea of what I'm trying to accomplish.

View 9 Replies View Related

Avoiding User From Inputting Duplicate Entry Into Single Cell In Excel

Dec 3, 2013

I have a worksheet in which i am asking a user to enter manually a number in cell E3. Suppose the user starts with 100, then the next time he is entering in E3 he shoudnt be able to enter 100 nor any number less than 100. I dont have a range for the numbers that the user is going to enter.Therefore countif function does not work. Is there any way that i an store the number taht the user enters first in cell E3 and then use that database to avoid the user from entering the same or a number lesser than that number.????

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

Removing Or Changing Data In A Cell By Inputting Date In Another Cell

Aug 4, 2014

cell a1 has yes cell b1 has yes and i want to type yes in c1 that will change a1 and b1 automatically to a blank cell

View 3 Replies View Related

Returning State Cities By Inputting Given State Abbreviation

Jun 3, 2012

I'm trying to create an array formula that returns all the cities in a given state by imputing the state's abb in cell K2. The returned cities go into column J. California has the most cities(430) and the cities are 5000 rows deep.

View 7 Replies View Related

Inputting List Of Names From Worksheet Into A List

Dec 21, 2013

Im still pretty new toi VBA and im struggling with pulling data from another worksheet and placing it into a list. Below is the code currently I think I have identified were its not working but not sure what to do. the code should essentially do the following

on opening the workbook check CS PS data worksheet find the names of people within the sheet, These start at row six and the step between each is 82 it then should input these names one after another in the following range Range("AO3:AO43") one name per cell until the end of the dat,a it seems to run but only inputs the first name in the first cell even thought it picks up each name in the myformula piece

Within the myformula there is a concatenate piece to flip the names to opposite way round I think this is where is not working possibly something to do with the separators? each name is in the format surname, firstname it should flip it so it shows first name [space] last name

provide ive commented out the piece I think is the issue

Sub CSupdate_()
With Application
.Calculation = xlManual
.ScreenUpdating = False

[Code]...

View 3 Replies View Related

Macro To Force Format And Check Barcode Check Digit

Nov 27, 2009

My company uses 4 types of barcodes 8, 12, 13, & 14 number barcodes for our products my problem is that I can't figure out how to force the barcode to format properly no matter how somebody enters it if they don't use spaces or put them in the wrong spots, I can't use custom formats because there is 4 different layouts

8 digit should be "#### ####"
12 digit should be "###### ######"
13 digit should be "# ###### ######"
14 digit should be "# ## ##### ######"

these barcodes are in columns L, M, & N also right now 'm using a formula in another cell to verify the barcodes by calculating the check digit and comparing it to the check digit typed the formula i'm using is

View 9 Replies View Related

VBA Check If A Cell Is Empty - Move 7 Cells Over And Check Again (Loop)

Aug 10, 2012

I have data in Row 53 that spans 7 columns, but stays in the same row. I want to design a loop to select every 7th cell in that row and check if it is empty. If not, add onto a "counter" then display the final number of occupied cells (the value of the counter) at the end. This is what I have so far, but I get all sorts of errors.

Code:
Sub Tester()

Dim WB As Workbook
Dim WS As Worksheets
Dim modCounter As Long
Dim Cell As Range

Set WB = Workbook("Transverse Series.xlsm")
Set WS = WB.Sheets(BM18)

[Code] ......

View 1 Replies View Related

VBA Spell Check - Dont Ask To Check Rest Of Doc?

Nov 3, 2008

I am using this code

View 5 Replies View Related

Check Box Controlling Other Check Boxes?

Jul 4, 2014

I want to have 1 check box affect 3 others in the following way: check box 1 if checked, allow check/uncheck of check boxes 2, 3, 4 if unchecked, uncheck boxes 2, 3, 4 and do not allow checking check box 1 is linked to D1 which starts with a value of false. cell E1 is if condition to have value 1 when D1 has value of true.

I have attempted to attach an example worksheet.

Test check control.xlsx

View 1 Replies View Related

Check All Check Boxes With CheckBox

Sep 9, 2007

I am creating a userform with 10 checkboxes. The first 9 checkboxes are user options. I want the 10th check box to be a "Select All" option i.e. if the 10th checkbox is checked all the other 9 options are deemed to have been selected.

The way I want the display to work is that if the 10th checkbox is ticked all other checkboxes are cleared. Also if the 10th checkbox is ticked and any of the other check boxes is selected then the 10th checkbox should be selected.

I have tried coding this up but the checkboxes don't seem to operate as desired. I placed some code on the click event for the last option button to set the vlaue for all other buttons to false. This works but the 10th check box doesn't get ticked itself. When I try to code up the other bit I get similar issues.

View 9 Replies View Related

Uncheck Check Box + Check A Option Button Using Command Button

Aug 20, 2009

When I press a command button I want to:

Uncheck a checkbox made with Control Toolbox

Check a particular Option Button within a group box made with the Forms Toolbar.

EDIT: Clarification, I want both things to happen when I click one button.

View 3 Replies View Related

Check Boxes Macro: Macro That Will Check If The Boxes Are Checked And If Not Ignore Them And If So Run A Certain Macro

Jul 28, 2006

I have numerous hyperlinks in cells on a worksheet, next to these I have checkboxes. I am looking for a macro that will check if the boxes are checked and if not ignore them and if so run a certain macro.

View 6 Replies View Related







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