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.
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.
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.
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 .
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...
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?
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.
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?
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.
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;
"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.
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.
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).
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?
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.
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.
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
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?
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
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.