I am using a check box on a form i have created. If it is unchecked (default = checked) then it enables a text box (default enable = false). The problem is if the user changes their mind and recheckes the check box it will not disable the the textbox. The text box stays enabled no matter what the check box's status is. I am unsure how to approuch making the following happen:
I have a spreadsheet setup which includes a number of checkboxes set up using the forms toolbar.
I would like to link each of these checkboxes (in sheet1) to a cell reference in sheet2. I'm trying to write a macro that will do this for me to save me right clicking, choosing format control etc for each checkbox.
I found the code on this page: http://www.mrexcel.com/archive2/51300/59643.htm which appears to be similar to what I am trying to achieve. In this case it creates the checkboxes in cells B3:B20 and links them to C3:C20.
I have already created all the checkboxes, and wish to use a macro to link them (for example) to C3:C20 in sheet2.
I have a ton of text boxes on a userform that are in an initial state of being disabled. Is there a quick way of enabling by use of a mask for these Text Boxes ?
All the text boxes I want to enable are named "TB_fieldname" and by mask I mean a snippet of code using something like "TB_*"
Example tb_liqname, tb_casecost, tb_bottleprice etc etc..
I need to extract text from the middle of a cell. I know you can use the MID function but with the complete function as i need to extract text string from Name to the end of their full name (I have highlighted below in bold). Of course their full name will change in each row.
Example text in cell B2: ID: 197993043 Name: Ben Fred Company: ID: 197992821 Name: Hello World!
I have a sheet in which some of the cells have two strings separated by a linefeed. I have come up with a cumbersome formula which will let me check if either of the two strings is a member of a list stored on another sheet. However, it fails if there is only one string in the cell, presumably as there is no linefeed for the formula to find. How can I modify the formula to cope with this situation?
There are also on occasions, three strings in the cell, but I can't seem to access the middle string with the formula. Simplified spreadsheet attached to show the problem. This must be formula-based, as we have a no VBA policy. If you think there is better way of doing this, please let me know.
In short I what to be able to check a check box and have the adjacent cell, which contains the tab name, to then reveal that tab and add a link to the tab to cell contain the tab name. I have done this with copying and pasting existing linked cells, but now I have 100 more to do and I do not want to write repetitive code to get it done.
I have 6 text boxes on 5 different tabs all with their own spin button that will push the number up or down, starting from the default value. How do i lock/restrict the text box entry so, the spin button is the only way of changing the value?
In Excel have a customer list, and notes associated with each of them. On my form, where I perform a search (by customer name), I would like to link the Text Box to the cell with notes. How can It be done dynamically?
I have a long list of Titles in Column A. I want to be able to paste a link into Column B and it automatically searches the text next to it. I would like it to be simple. Something that is the same for every row, so I can bulk copy and paste.
I'm trying to create a dynamic chart title by inserting a text box in the chart title that displays the value of the last populated cell in column A. The number of rows increases over time, so I'm trying to come up with a dynamic cell reference. When I hover over the text box a tool tip appears with this text "TextBox 2" so I assume that is the name of the text box. I'm definitely open to other methods that do not use vba. It seems that none of this code can activate the text box:
Code: Sub textbox() Worksheets("Figure3-5").TextBoxes("TextBox 2").Range("A" & Rows.Count).End(xlUp).Value End Sub
setting up a worksheet that forces a link to another worksheet when text is entered.
For instance, I will have several columns in the first worksheet (Sheet 1). For each entry, a tally ("X") will be added under the applicable columns. Most of the column headings are pretty straightforward. To keep things uncluttered, I want one of the columns to have an auto-link (?) feature so that when the user adds an X in this one column (we'll call it Column D), the user will then be auto-linked to another worksheet (Sheet 2) in the workbook. Sheet 2 will have room for more information regarding Column D, Sheet 1.
I have created a cover sheet with various command buttons linking into the available worksheets. I was wondering if it is possible to set the title of the command buttons by linking them to the text in a particular cell in each work sheet??
I have two worksheets, one with detail monthly information and one with YTD information. So let's say the three numbers I want to capture in the YTD sheet are in columns B, G and I on the monthly sheet. January's data might be in B5, G5 and I5. February's data is in B12, G12 and I12 and so on.
On the YTD sheet in cell C2 I link to Monthly!B5 and in C3 I link to Monthly!B12 so cells C2 to C13 on the YTD sheet show the monthly totals from column B on the detail sheet. On the YTD sheet, cells C20 to C31 show the monthly totals from column G on the monthly sheet, so cells G5, G12, etc. And finally, cells C40 to C51 on the YTD sheet show monthly totals form column I on the monthly sheet.
In the past I've always created all these links manually. After creating the links in C2 to C13 on the YTD sheet, is there a way to use a formula in C21 that uses the link in C2 to create a link for G5?
I have 2 tabs in a 2013 workbook. Inventory Receipts and lookups. One of the Data verification lookups I have is a drop down list in each cell in Column B (eg: Cat, Dog, Mouse) In the lookups tab I have another cell range containing the sounds (eg: Meow, Bark, Squeak).
What I am trying to acheive is, if B2 contains Cat, then return Meow in B3, if B2 contains Dog then return bark in b3 and if B2 contains Mouse return squeak in B3. Ideally I would like the formula to return the text from my lookup sheet (eg: 'Lookups'!C2,'Lookups'!C3,'Lookups'!C4). So depending on which option they choose from my animal drop down list .. the correct noise would automatically fill in.
I have 3 columns, C1, C2, C3. I have to return a value for the following conditions
1. Check for the presence of a particular text in the C 1 (duplicate values can be present) 2. Check for the maximum value in C2, if the second for the particular text from the first column (duplicate values can be present) 3. If the text is found, I need to return the Maximum value from column 3. Else I need to return 0.
My formula has been returning zero despite the fact that I have a larger valid value in column C3.
The formula(s) I have been running is 1. IF((AND(C1 = "E", Max(C2))), (C3),0) 2. IF((AND(C1 = "E", Max(C2))),MAX (C3),0) (In case of duplicated in C3) 3. IF((AND(C1 = "E", Max(C2))),MAXA(C3),0)
For all bank transactions I've downloaded, I would like to add a subject. The list contains many hundreds of rows, so I tried to make a macro for it. Unfortunately I cannot manage to search if a cell contains a certain text string. I came up to:
Can the below be achieved with any formulae or macro -
I have 2 worksheets (sheet1 & sheet2). In sheet2, i have some colors in column A (e.g. "red" in A1, "blue" in A2, "green" in A3.
In sheet1, i have some text strings in column A, e.g.
A1: I love red color A2: my pen in blue A3: Green grass A4: Orange juice A5: I like red and blue
What i want in corresponding cells in column B, is the name of the color which is in column A. so my output should be
B1: red B2: blue B3: green B4: "NIL" (any error message) B5: red (even though it contains 2 color, i am happy to show any one of the colors it contains)
I want to write a formular to initiate an action if a particular text is not in a list For example, I have a list in column D1:D50, and I want the following to happen in say cell A1
If "apple" is not in list D1:D50, then in put "N" in cell A1, else input "Y".
am trying to write code to check if a cell contains specific text.
Basically, I hide all of the rows on the spreadsheet, and unhide them only if certain conditions are true.
Everything else, including first check is not a problem, it is just the part where I need to find specific text within a cell that contains various words.
Also, the cell I am searching for the text in is on a different sheet within the same book.
e.g. ------------------------ 'Check for Specific parts If Cells(intCount, 11).Value = "Yes" And ??(Does Cell 'x' (on a different worksheet) Contain the Word "Specific")? Then
'Select row Rows(intCount).Select 'hide row Selection.EntireRow.Hidden = False End If ------------------------
I'm trying to identify if text contained in one cell is also contained in another cell. I used the following formula with some success, but it is not successful in all situations, and I don't know why.
I have a textbox in a form and i need to check if the text posted there begins with zero or if it contains spaces. Ex:
05E 9050 01 if this is the text then it shoud warn me becouse there is a zero in the begining and it contain spaces 4P 565001 if this is the text then it shoud warn me becouse there is a space
