Enter Text Depending On Another Cell

Apr 8, 2007

I have a spreadsheet which is attached. I want text to be entered into column A only if there is text in column B. The text to be entered is taken from a cell in another workbook. I have removed the lin to up it to this fourm.

View 5 Replies


ADVERTISEMENT

Single Cell Value From Either Dropdown List Or Enter Manually Depending On Selection

Jun 22, 2014

I have a cell in my spreadsheet that I use to control the size of a column. I formatted the cell as a number and added data validation to make sure the number is greater than zero. Then I realized that I need to also allow for the option of auto sizing the column as well. This would require a data validation list type with something like True and False for the choices.

What I want to be able to do is have it both ways. I want a drop down list in that cell with the options Auto Size or Custom. If Auto Size is selected the cell value gets set to that. If Custom is selected I then want to be able to type in a number.

ddl.png

[URL]

Is there a way to setup a cell such that the value is either an item from the drop down list or, entered directly (depending on the list selection)?

I know I can do it with dependent lists but that would require two cells, one for the auto size mode (true/false) and the other for manual width value.

View 1 Replies View Related

Program Tab & Enter Keys Depending On Control

Jan 4, 2007

Following are the VBA Object in excel file :

1.TextBox1
2.TextBox2
3. CommandButton1
4. CommandButton2
5. CommandButton3

i want to do following items :
1. when i am in textbox1 and press TAB button from keyboard then cursor go to Textbox2
2. when i am in textbox2 and press TAB (keyboard) then select commandButton1
3. when i am in textbox2 and press enter button (Keyboard) then run the macro of commandButton1 click event.

Actully above VBA object in excel sheet and i am not useing any fram for them .

how to possible above items.

View 9 Replies View Related

Enter Text In One Cell If Specific Text Is Present In Another Cell

May 9, 2008

is there a formula that will find a word in a sentence written in a cell and if present then enter specif text in another cell? for example, if the word "Hotel" appears in the sentence in cell A5 then put in the text "Hotel and subsistence" in cell B5...

View 2 Replies View Related

Userform To Enter Data In Different Locations Depending On Selected Options

Jan 22, 2009

MONDAY
xxxxxxxxxxxxxTeam1 | Team2 | Team3 | Team4 etc.
Hours State1
-
Hours State2
-
Hours State3
-
etc.

TUESDAY
xxxxxxxxxxxxxTeam1 | Team2 | Team3 | Team4 etc.
Hours State1
-
Hours State2
-
Hours State3
-
etc.
WEDNESDAY
xxxxxxxxxxxxxTeam1 | Team2 | Team3 | Team4 etc.
Hours State1
-
Hours State2
-
Hours State3
-
etc.

Each team leader would then input hours in each state each day on their column. Make sense? Easy Peasy...

My question........... is it posible to have a userform where a TL would select their name (Column) and Day (Monday=Row 3, Tuesday=Row23 etc) from a dropdown and then input figures in txt boxes to submit them in the correct location?

View 9 Replies View Related

Can't Enter Text In Cell

Aug 2, 2014

When I click on a cell to enter text, a new little text window pops up inside the cell and doesn't allow me to enter text. No matter where I click in the cell another little text window appears. I also can't delete the text in the cell because the little text window pops up again and again.

Here's a pic of it: [URL]....

View 9 Replies View Related

Return Text Depending On Another Cell

Jan 8, 2007

I have a very long excel sheet. What I want to do is, depending on the input in one column (text), return a another text in another column, for the whole sheet.

I tried to with Select Case Statement and if-then, but couldn't figure it out since I don't have much VBA experience.

View 6 Replies View Related

Return Value Depending On Text In Cell

Mar 1, 2008

I have a cell A5 in a worksheet that can be either E or W. I am looking for a formula in Cell A10 in the same worksheet to return numeric values of either +1 if cell A5 is W or -1 if cell A5 is E

View 3 Replies View Related

Enter Text Based On Cell Value

Oct 9, 2009

Not sure why this won't work. Just want to insert the text line "11 color" in column "I" if a user enters a number higher than 199 in column "G".

View 3 Replies View Related

Highlighting Cell Color Depending On Text

Sep 15, 2014

See attached work book, it is an mot booking system that is all working fine except for one thing that I don't know how to change.

At the moment if you double click a cell in the test type column it enters the required data and turns the cell green highlighting the length of time and values this is all good but I am wanting the ones that start with n-side to turn yellow just so that we can see our own internal tests easily. It is control in the coding not formatting . Is there a way this can be done?

View 2 Replies View Related

Cell Shading Macro Depending On Text

May 30, 2008

I will have a spreadsheet similar to the image provided. Basically, I need the macro to go row by row down column I. If the cell in column I contains the word "Tech" I need the cells from column B to P to be shaded color1; if it contains "Update," color 2; if the cell is blank; leave the cell as is. Once the macro has done this, it will continue to the next row and to the same check.

The number of rows in the spreadsheet will change on a day-to-day basis depending on the data that's pulled, but the columns should remain the same.

So I think I have the shading part. This is what I have so far. I'm not sure if this is the most efficient way of coding it, but it kinda works. I guess another problem would be if in the future the column with this info (column I) changes and shifts.

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

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

How To Make Cell Enter Text Automatically

Jan 6, 2014

In column B I will be entering a number and I would like it to automatically enter gallons in column c when i do so. So if i enter 356 in b2 i want it to say gallons in c2.

View 1 Replies View Related

Enter Data In Textbox And Go To Cell Containing That Text

Oct 19, 2011

I have a very long spreadsheet with about 3000 rows. lets say for simplicity that column A contains a list of product ID numbers. I am looking for some macro code where I can just type in the product ID into a textbox, then hit enter (or a 'go' button) and then the cursor will move to the cell containing the part number.

I know Ctrl+F will do the job for me, but because of the frequency that I do these searches, a text input box would be easier still.

The nearest solution I could find was the one here Find text but its a bit 'overkill' for my needs.

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

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

Search A Range To Enter Text In Adjacent Cell

Jul 19, 2006

When i press say a command button " Add Repair Information" i want the User to Enter the serial number which i have given it a range called SerialN from the excel sheet and enter a repair action. Is there a function in Excel which will allow me to search the Serial Number and allow me to put the Repair action across in the cell on the same line?

View 5 Replies View Related

Conditional Formatting - Highlight Color Of Text In Particular Cell Depending On Value

Dec 22, 2013

I would like to know the formula to highlight the color of text in particular cell if the value of the particular cell ( value is text ) is so and so.

For Ex: If the J6 is "Vacation" then the J1 text should be in red color.

View 5 Replies View Related

Remove Certain Text From Cell Depending On Another Cell?

Nov 28, 2012

I have a cell in a column A1 where is written: "XYZ 492" and in another Column is written "492".

Now I want to remove the "492" out of the first cell with a furmular.

View 4 Replies View Related

Inscribing Cells: Run A Macro On Enter Keypress, That Would Execute Different Code Depending On That "inscription" That Would Be Invisible To User

Feb 20, 2007

Is there any way to "Inscribe" a cell? I would like to run a macro on Enter keypress, that would execute different code depending on that "inscription" that would be invisible to user. I could use some properties of . Validation property like this:

Private Sub EnterPressed
'following code to ensure proper functioning of Enter in any other Worksheet
If ActiveSheet <> mySheet 'MySheet is global Variable then
ActiveCell.Offset(1,0).Select
exit Sub
End If
'now the real code
If ActiveCell.Validation.InputMessage = "1" Then
ActiveCell.Offset(0,1).Select
Else
'something else
End If
End Sub

The problem is, I use Data Validation and Conditional Formatting, so can't use any of these properties.

View 8 Replies View Related

Macro To Find Text Box #9 Enter Text

Dec 9, 2009

The macro recorder doesn't let me record a macro that finds text box #9, go to the end of the existing text in the text box and then add my text.

When I record the macro and go to the box, it doesn't appear in the code (as well as not working).

View 9 Replies View Related

Alt & Enter When Using Text

Nov 28, 2008

I have manually set all row heights to 12.75 to make sure they are the same. In these rows I have a comments box and when the end of the cell is reached I use alt&enter to continue writing underneath. Seems the comments cell has stopped re-sizing.

View 2 Replies View Related

Text Box Run After Enter

Sep 29, 2009

how can i define in code, that my code will start after pressing "enter"?
i have textbox, i write something and i have a code. I want only launch my code after pressing enter.

View 5 Replies View Related

Display R, A Or G Depending On Text In 2 Other Cells

Apr 15, 2009

I am trying to nest a formula with IF & AND to work out a RAG status. I have 2 questions per row (in Columns I:J) which will be answered either Yes or No. For each combination I need to give a RAG status in Column K e.g. two Yes replies give Green, 2 No replies give no and one No out of 2 will give Amber

Below is hoped for response in Column K:

ColI---Col--- JCol K
Q1----Q2----RAG
Yes---Yes---G
Yes---No----A
No----Yes---A
No----No----R

View 3 Replies View Related

Add Or Subtract Depending On Text Value In Another Column

May 3, 2007

I have a workbook to record the attendance of students. Sheet attendance9 for September's attendance. Enter 1 for present, 0 for absent, L for late, E for early leave and blank cell for no schoolday. Sheet "remark9" is used to record detail of attendance for September. In sheet "attendance9", I want to display in cell AT2 the number of times a student absent for 7 or 14 consecutive days. How to count from E2:AH2?

View 6 Replies View Related

Add Enter To Text From Array

May 17, 2014

I'm trying to add an enter space to text with the combination of a loop and an array, but I cannot find the right combination so that the final result appears as so:

ArrayItem
Desired Text
or via excel
=NamedRange&"
Desired Text"

Here is the code for the loop, trying to add the appendage to the first item after the if.

[Code] .....

View 1 Replies View Related

Set Font Size Depending On Length Of Text

Sep 3, 2007

When a number is entered in cell S3, it triggers formulas throughout the worksheet to populate the it with information from another sheet. If the length of the text in B6 is greater than 80, the font size for B6 only should be 8; if the length of the text in B6 is less than or equal to 80, the font size for B6 should be 10. Regardless of the length of the text in B6, the font size for the rest of the sheet should not be changed.

I tried the following
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address "$B$6" And Target.Count > 1 Then Exit Sub
Dim cnt As Long
cnt = Len(Cells(6, 2).Value)
If cnt > 80 Then Cells(6, 2).Font.Size = 8
ElseIf cnt < 80 Then
Cells(6, 2).Font.Size = 10
End If
End Sub

View 9 Replies View Related

Enter Number Of Spaces In The Text

Jul 12, 2014

How can I enter a number of space in the text file and yhis number is existing in other cell.

Example:

=CONCATENATE(G4," ",I4," ",J4," ",K4," ",L4," ")

the number of spaces is given in other cells.

First space is F1 = 4
Second space is F2 = 8
and so on

View 3 Replies View Related

Textbox That When Enter And Tabs Within Text Box

Aug 14, 2007

I have text that when you push enter it goes to the next line and when you push tab it goes 5 spaces to the right the problem is...

When i have a lot of data it goes out of range and not all of the text is shown. I want to limit what is written to the size of the text box no matter the size or type the font is you can only type where you can see inside the textbox.

View 8 Replies View Related







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