limit

Hi, I have a textbox1 within a userform that I would like to limit to a minimum of 18 characters. If the textbox1 has less than 18 then I would like a message box to say so. Any help would be much appreciated. Kind Regards Dan

How to use Goal Seek to change the period of the loan to limit dollar amount?

Hi, I am trying to ascertain the number of days it would take the Firm to exit each stock held across two strategies (each with a number of portfolios), given the percentage weight holding in each of the portfolios in the strategy, the value of each portfolio in dollars, the average daily $...

I entered this: =SUM(J7,J11,J15,J19,J23,J27,J31,J35,J39,J43,J47,J51,J55,J59,J63,J67,J71,J75,J79,J83,J87,J91,J95,J99,J103,J107,J111,J115,J119,J123,J127) Can some one help with is there a limit I need to increase etc etc thanks

How do I build a formula from a string? Lets say I have 10 user defined functions... (sam, fred, mary,...) and I want to build the formula in the spreadsheet. I can use a data validated cell to limit the function to the list of UDF's. Then I want to create the formula as a string...

Hi Guys, I am trying to put a data picker (calendar popup) in a column in a table (table[column]) that will popup whenever the cell/field is selected. All the solution that I googled and found refer to a range. The problem is that I not very good in VBA and i want to limit the popup only to the...

I currently have this formula =IF(L3<>"",L3, "") pulling text descriptions from cells, and ignoring blank cells, but need to limit the character length to 15 characters. I tried nesting a (LEFT(L3,15)) function, but it would not take. Is there a way to do this? I tried this but it wouldn't...

I am trying to take the median of a range of values, filtered by the number in the limit column. As small subset of the data is below. For example, I need to write a function that finds the median of all the values for records with a Limit of 500. In this subset of data the function should...

Hello, The following code I have recorded as an array formula but it runs as a run-time error 1004. It is 246 characters, so under the limit of 256 - any ideas why it will not work please? Range("T10").FormulaArray =...

Has anyone used the ScrollArea property extensively to limit access to a worksheet? From my limited use, it seems to be flaky, ie if I set it to C:F and say column A is hidden, I have found I cannot unhide it.

Is it possible to prevent users to put pictures in the worksheet? I want to limit input to data only.

The following is a simple way I found on this site to enter dates for various date types. How can I limit the macros to only run on specific rows 6:14? Sub DateStamp() Range("B" & ActiveCell.Row).Select ActiveCell.Value = Date End Sub

Hi, I've been trying to find an alternative to the substitute function where im not limited to the 64 limit nesting rule. At the moment my current forumla has hit the cap. I've tried using vlookup with a table but it doesn't give me the same desired result. What the forumla does is this, in one...

Hi, can someone help me with the following : let's say I have a variable and let's make it =4 for this example I need to have a formula that will generate the following rows : 1 2 3 4 3 2 1 2 3 4 3 2 1 .... and so on... Any ideas ?

Hi! I got a timesheet, one sheet for each month, and a totals sheet where I also set hourly wage, extras for evenings and weekends, as well as tax %-age and a tax-free limit. Now, if I set the tax-free limit to 50000NOK, £5000, it takes everything within that day as tax-free, but the hard limit...

I'm using Excel as a primitive but very practical offline grid database. When needed, the Excel file is then uploaded and it populates a mySQL db. Now I added the support to images by encoding them base64 and save the string into a cell (mySQL will use the content of the cell to fill a BLOB...

Dear Excel Experts Trying to solve problem with macro. However, my VBA coding skills are basic. Any help or hint is welcome Here is code written correctly(code is not written by me) Private Sub Worksheet_Calculate()'Check if values haven't changed If Range("F13").Value = Cells(Rows.Count...

Hi There, SO I have created a large spreadsheet but my main concern is between three data validation columns that are all working together. Column A -- You choose from a dropdown list for a particular reason Column B -- You choose state based on the region you choose Column C -- You choose...

Hi everybody. Hoping someone could give me some help with the below query. I need to find out how many hours workers are doing above their contract. These fall into two pay rates. Any hours done up to 37.5 is paid at one rate (Extra Time), and any hours over 37.5 (Over Time) is paid at another...

Hello Excel Fans, I would like to be able to allow access to the workbook by anyone within the network, and allow them to copy cells or complete worksheets, but not allow any changes to the Work Book. I have not been able to find the way. Anyone know how to do this. Thanks