User Profile
Tamara9927
Copper Contributor
Joined Aug 31, 2022
User Widgets
Recent Discussions
Using a checkbox to toggle the Char(10) command inside a textbox now working
Hi All, I am attempting to build a crude text editor by using 4 checkboxes in a row, where the first 3 checkboxes toggle on and off individual text strings in other cells, and the 4th checkbox is linked to a cell that contains the =char(10) function, to add line breaks when I choose to add them. I have 20 lines of these checkboxes in a vertical column, and corresponding cells that contain text that display if it's checkbox is checked ("TRUE"). I then have another very basic equation just using ampersands "&'s" that join each horizontal line of texts toegther on the right hand side into 1 result cell, and a final equation (again using ampersands) that vertically gathers up these result cells into one big final result cell. Lastly, I made an Activ-X text box, and linked that to that final result cell to display these results more visually as sort of interactive essay. I am using the ampersand characters to keep everything very simple, since what I wanted to do didnt work with the TEXTJOIN command, and I thought that was the problem. Each horizontal line (using the first three checkboxes) succesfully joins the text strings together, and the result boxes work perfectly, and put everything together into one result, and I can see that in the text box. As one big long string of text. No problem there. What I want to do, however, is to be able to use the 4th checkbox on each horizontal line to add a line break if I want (toggle on and off the char(10) function to add in a line break). And that's where I'm running into a problem. I have the properties of the Activ-X text box set to "Wrap Text". But Excel is treating my "=char(1)" as text, not as a command. The 4th checkbox is correctly linked to the cell with the "=char(10)" command in it, and that "=char(10)" cell is formatted to "general". So I'm not sure how I can get this to work. = / Any ideas? A large thank you in advance to all you brilliant folks who take these questions on. You're life-savers. : )Solved170Views0likes4CommentsRe: Hi! - asking for a solution to an equation that has me stumped, if I may...
Patrick2788 Ohmygoodness. You did it AGAIN!!!!!!!!!!!!!!! I cannot thank you enough!! I can see now that I was apparently on the right track, but I definitely did it incorrectly. Thank you for teaching me!!! You're the best!!!! : ) Tamara <3!!!2.1KViews0likes0CommentsRe: Hi! - asking for a solution to an equation that has me stumped, if I may...
Thank you again for this.... it works wonderfully!!! I am now wondering if there is a way to make this equation adaptable to work with different numbers of rows, without having to change the ranges to fit the number of rows each time? How can I make the cell references of $A$8 and $B$8 just automatically match how ever many rows I cut and paste into the spreadsheet? I tried using Index and that didn't seem to work...I tried using a COUNTA function to determine the number of rows and then use the VALUE of that cell as a quantity reference inside your equation, and THAT didn't work... so once again, I am stumped. Any further ideas? : ) I'm using Excel 2019 Home and Student.2.2KViews0likes2CommentsHi! - asking for a solution to an equation that has me stumped, if I may...
I am a bit further along than beginner, but by no means advanced, so please forgive me if my query seems obvious to someone. But I have tried to build an equation to solve the following problem, and I'm not getting anywhere. Thank you to all in advance! The problem I am trying to solve, is that for all instances of a particular number in one column, I want to compare their corresponding associated values in a different column with each other, to see if they are the same. I will explain this a little differently, for nuance: In a regular Excel spreadsheet I have rows of data, and each one has data points in columns A and B. In each cell in column A, there is a six digit number. Within column A, some of these numbers repeat, but not all. All of the same numbers are right next to each other in column A, because I ordered them (and their respective rows) by their number values, low to high. In column B, there is a text string, either "TRUE" or "FALSE". What I am trying to do, for all instances of a particular number in column A, is to compare their corresponding values in the same rows in column B with each other, to see if ALL of the corresponding values in the B column are saying "TRUE". So in the following example, taking the first number, 133235 (A2), there are three examples of that in column A: A2, A3, and A4. So what I want to do, is to compare B2, B3, and B4 with each other, to see if B2, B3, and B4 all have the value as "True". If ALL THREE B values are "True", then I want to put the value "TRUE" into C2, C3, and C4 (which is messy, but only because I will be putting this same formula into every cell in the C column). I've supplied several result examples for you based on the data below, so you can see what I am looking for: Column A Column B Column C 133235 True False 133235 False False 133235 False False 182374 True True 171532 False False 922161 True True 922161 True True If even one of the corrseponding values in column B is false, column C needs to return a value of false. For all of the rows in column A that are the same number, only if all of the corresponding values in column B are True, should the value in column C return as "True". I hope that makes sense. I'm having quite a difficult time with this. Thank you all so much!! 🙂2.5KViews0likes5Comments
Recent Blog Articles
No content to show