I have a form in Excel that has comments fields. Each comments field is a merged cell consisting of four rows and four columns. My understanding is that Excel should be able to display 1024 characters. The input that's causing me trouble has 360 characters. At around 300 characters, the text box gets filled with ############################# instead of text.
If I size the font down significantly to where there would be absolutely no question that the text would fit, it is still #######. I may have to end up using text boxes, but they are a bit troublesome for the less Excel-savvy users of the form.
I have a workbook with two worksheets. I added a formula to the first worksheet = COUNTIF(Scorecard!H3,"K"). It works fine when I add another COUNTIF that references another column (baseball fans may realize I'm counting total strikeouts for a batter): =COUNTIF(Scorecard!H3,"K")+COUNTIF(Scorecard!L3,"K") However, when I try to expand this to cover more columns, =COUNTIF(Scorecard!H3,"K")+COUNTIF(Scorecard!L3,"K")+COUNTIF(Scorecard!P3,"K")
Excel automatically changes the format of this cell to "Text" and it shows the formula as text instead of calculating it. What could be wrong here? Excel's documentation is woefully inadequate for cases like this. Is there an undocumented limit on how many times I can add COUNTIFs together?
I just reinstalled windows (XP) and Office 2003, SP3. When entering text in a column and if it was larger than the current column, it used to just display into the next column unless there was data in that column.
Now, it just displays a few letter from the end of the first word. How can I change this back as default?
I am submitting a book CSV file to my website. However, the website will not accept any cell that contains more than 80 characters. The error states the following. "WARNING: Title should be less than or equal to 80 chars; your Title was truncated to 80 chars" repeated 13 times.
i need help with 2 formulas to return text within a longer string.
the first result i need is a style #. this will always start at the 5th character, but the length is variable. it will always end right before the last "/" or "" in the string (there may or may not be a / or within the style number)
the 2nd result i need is a description of the style. this will always be after the last "/" or "" in the string and end before a ".", but there may not always be a period in the string.
Text string: ABC123123BASIC TEE.black Style # result: 123123 Description result: BASIC TEE
Text string: DEF/4567LEAH/FLORAL TANK DRESS Style # result: 4567LEAH Description result: FLORAL TANK DRESS
Excel turn some of these ranges into dates such as 01-Oct, which is extremely annoying. But trying to change to different date formats but it still keep it to dates. what I can do?
I have a spreadsheet full of data and in one column the are a set of text codes some of them start with a -... ie -AGEST excel automatically turns this into #NAME?
I am trying to paste in a decimal equivalent chart, loacted here:
http://www.advancedtool.com/prod02111.asp
which basically has a mixture of whole numbers and fractions, and how they equate in decimals.
When I paste this in, all the fractions turn into dates. So for instance 1/64 turns into Jan/64, and 1/32 is Jan/32. Now, I could go in and change each one, but I would like to know how to do this with cell format on the entire sheet....
I have tried to change the cell formats to "general" or "text" and of course fraction, but in this case, I have to go in and do each fraction cell individually. Now maybe I am being too lazy, and in the time it took me to look up my login information, and type this out, I likely could have re-done the worksheet, each cell individually, but I would like to know the way to fix this automatically.
I'm trying to keep some basketball stats, and from ESPN the field goals are reported as 10-16, or 5-14, to indicate how many field goals were made out of attempts.
When I paste this into Excel it automatically interprets it as a date. So 10-16 turns into Oct-16, and 5-14 turns into May-14. How do I stop this?
I have put together a simple example of my problem. There is two buttons and one text-box "TextBox 1". When I use the following code:
[Code] .........
I get one button to hide the textbox and the other to show it. Initially the textbox has the textbox properties (you can type in it) but when I hide it and show it again using the two buttons the textbox becomes like a rectangle shape which I can not type in and can only click.
How do I hide and show the text box whilst keeping it as a text box?
A little context: Searching this forum for "sleep", "delay" or "animation" will bring up a host of threads referring to the kernel32 function, sleep. This is a great way of putting small delays into code without the potential "synchronisation" problems of application .ontime calls or the "ugliness" of multiple-thousands looping.
My question: When I call sleep (with values in the hundreds of milliseconds) several times in a macro, it seems like the computer just "gives up" screen updating after a few (maybe 50) iterations. The macro still takes the time I'd expect, accounting for all the sleeps, but it stops showing the intermediate steps and just shows the end result after the macro ends.
Is this something to do with RAM? Is there something about calling this command too much or too frequently that kernel32 doesn't like? Is my computer a useless bag of nails and spit?
In a column in my spreadsheet i have to input a number; either: 51-61 and next to it is either m or o. so in Column A row 1 : 51m, Column A row 2 60m, etc Example:
51m 51o 55o 60m
I want to conditionally format this such that for 51 it turns the cell background green, for 52 red, 53 orange,etc. with a number having a specific color associated with it. 03' does not have a text choice.
i have the volume of a reservoir in column A for lets say, 2 years, with monthly data (so 24 numbers in my list)
I also have some variables that feed into this list such as rainfall (fixed), and population (i.e water use, which i can manually change)
if i increase the population too much, the volume of the reservoir will at certain times of the year, fall into negative digits.
what i'm looking for, is a cell which works out the maximum value (in whole numbers) for my population, without any of the numbers in the reservoir volume list falling below zero.
When using the autofilter, the drop-down arrow turns blue in color, i.e., when some filter citerion is being used, the small down-arrow turns a different color as a way of informing the user that a filter is in place. Is there a way to control the color of this? Currently, mine turns blue, but it would be more useful if I could change it to a brilliant color in order to make it contrast more with the default black. Blue is too difficult to be distinguished by my eyes. The autofilter is turned on via a macro. If there a line of code that controls the color.
Is it possible to make a textbox entry be a number.
I have a text box on a sheet and i have linked it to a cell on a different sheet.
The problem I am having is that when I enter a number in the text box say 2.8 it is stored in the linked cell as text. is it possible to have the entry be number as I need it to be a % and used in other formulars?
I have often used Data Validation List to create selection lists for cells in a worksheet. The problem is the list has to be on the same sheet you want to use it on. Is there any other way to do this so one common list can be used for all sheets? I have a list of accounts I want to use on 12 different Monthly tabs.
In the attached workbook - the stock Inventory is increased, every second day, by the value shown in cells of column A. Column B displays the date of the update. I'm looking for a Formula (might be an Array Formula) that will return the latest date before the stock turns to be greater than the value in cell D3. I managed to solve it, in cell F3, but with the help column C.
I am having is on the user form I have a default start time test box and a default finish time text box that when the form is opened it looks at the constants work sheet and if there is any data it puts it into the appropriate text box, all ok so far when a user wishes to change the default data in these text boxes I need to test if they are entering the data correctly, in Access 2000 I would set the defeat format of the text box to Time? Data type=Format(time,”h:mm”) or a or an input mask of “h:mm” so if they did not enter the time in the correct way an error message would pop up and tell them to renter the data the correct way. I have not been able to find this type of settings in Excel 2000 I have tried testing the data using the beforupdate but it also dos not recognise formatting
The other thing I need to do on the user form with this formatting is calculate the time difference between to two time inputs and come up with a total hours. I have managed to do all of this in the work sheets and preforms well but not on the user form
I need a macro which will put "P" when the cursor will be moved by right arrow key in the range c19 to AG55 if the cells are blank suppose cursor is moved from c19 to c20 & if c20 is blank then "P" will come on, if c20 is not blank say "Z" is in c20,then at c20 "Z" will remain at c20 and the code will not put "P" at c20 then.
I've a long list of value with indicator which I need to compare with an entry after which it need to return a text indicator. I'm using IF and MATCH function.
I am relatively new to Excel. I have figured out how to use named ranges as lists and use INDIRECT Data Validation to have a list's selection made in one cell populate a new list in an adjacent cell.
A1 contains a list of "Characters" (The choices are "Numbers", "Letters", or "Other")
Based on the choice in A1, B1 has to populate with the following:
- A list of available Numbers to chose from (1,2,3..etc) - A list of available Letters to chose from ( A,B,C...etc) - Text that instructs the user to enter text into the cell manually
(For example, their "Other" character might be something like "@#$%^&*!". (Not unlike my mental state trying to figure out this problem.) I want them to see the instruction to "ENTER CHARACTERS HERE" and then be able to type in the cell.
So I need B1 to either populate with a menu that is dependent on the menu selection in A1, or allow for free text entry depending on if they chose the "other" option in A1.
In I34 I have the same date again, except formatted as MMMM YYYY so its showing "March 2009".
In G10, I want the cell to read: Number at end of March 2009, with the month and year being taken from the date range. To be honest, I can get the year okay using the Year() function but cant get the month as cant convert it back from a numeric.
I currently have showing 800 suppliers in a List Box... sadly when having to search for a sepcific supplier this seems to be very fustrating and time comsuming for people in the Company.
I have tried the method of copying all of the Supplier above the list, so it can do an AutoComplete filter, but the data needs to be exact.
What i would really like is if i was to type the letter "V" in the cell, it would be able to provide me with a list of the "V" suppliers in a list.
I have a problem with entering 12-hour time data in excel.
If I key in 3:00, Excel will recognise it as 3:00 AM. If I key in 3:00 p, Excel will recognise it as a text entry. To get Excel to recognise it as 3:00 PM, I have to use the 24-hour format. i.e. I have to type 15:00.
I have checked the Regional and Language option in the Control Panel. Everything looks fine.
Does anyone have such encounter with Excel before?
A form loads and the first thing the user is to do is enter a specific date in a text box (preferably in, "mm/dd/yyyy" format.)
Is there any way to set up the text box so that when the form loads, the, "/"'s (slashes) are already in place? And can I set it up so that if the user enters in the date in any other manner aside from, "mm/dd/yyyy", that it will give them an error?
Finally, I want the user's date input to store on a worksheet (in row, "G".) So the first time the user uses the form, they type in a date and it stores the date in the FIRST AVAILABLE CELL IN ROW, "G." (example: "G1") The next time they use the form and type in a date, it is to store in, "G2", then in, "G3", ect. Each time they fill out the form, the new entry is to save in the next row beneath the previous entry.....
For other text boxes and combo boxes I have been using the following code to do this:
Sheets("Sheet1").Range("A" & intRow) = Text.Value (or Combobox.Value - depending on whether it was a text box or a combo box.)
Unfortunately I have NO idea how to apply this logic in regards to text boxes that are to store dates.
I am using Excel 2003, my problem is that I have cells D4 & E4 with red text, when an entry is made in B4 (say $640, the amount can vary) I want the text in D4 & E4 to turn black. I have attached a section of the document in question.
