excel forms

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Excel
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Printing text box with hidden text I'm looking for some help with a problem I'm having with a "drawing tools" text box. I have a form that contains a text box. The problem is when a user types into the text box and exceeds the box, they can continue to enter text past what appears on the displayed box. When the form is printed out, what ever was not displayed on screen is truncated. So, is it possible to limit the text box to be locked from scrolling? Or, is there a way to get Excel to print the entire contents of the text box? Thanks for any help on this quirky problem. Geoff Tag: excel forms Tag: 76997
  - 2
    - Duplicate Lines Hi All, Just have a question i am running a report daily that will have many items on there the same on a daliy basis. to stop me from checking over orders twice i am wanting to import a new sheet into the spreadsheet paste the new data and then do a fuction or something that if sheet1 D2 and H2 = the same as one of my lines in the sheet2 (1-8000) it will display what is typed into Sheet 1 N Tag: excel forms Tag: 76991
  - 3
    - Applying a template to an existing file I'm curious to know if you can apply a template's format to an existing spreadsheet file? My situation is this: I have an Access database that is generating between 50 and 100 Excel spreadsheet files. I want to know if there is an automated way in which I can apply the formatting from template to those files or to I have to do that manually? Thanks, Frank Tag: excel forms Tag: 76988
  - 4
    - Count records b/w time range I have a sheet which has data with date & time fields like this 19/10/2005 10:10 19/10/2005 11:30 19/10/2005 12:12 19/10/2005 12:15 19/10/2005 10:12 How do I make a formula to pull out count between each half hour slot? like: 10:00 - 10:30 =2 10:30 - 11:00 =0 11:00 - 11:30 =1 11:30 - 12:00 =0 12:00 - 12:30 =2 Please help. Cheers! Sunny Tag: excel forms Tag: 76987
  - 5
    - help So I have a spreasheet and on sheet one, Column B are SS# and on Sheet 2 Column B are also SS#, I need to match the SS# and if they match then I need to fill in column I on sheet one with the date that is in Column B on sheet 2. Is there an easy way to do this in Excel??? Any help is always appreciated. Thanks, C -- carley465 ------------------------------------------------------------------------ carley465's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28085 View this thread: http://www.excelforum.com/showthread.php?threadid=483665 Tag: excel forms Tag: 76984
  - 6
    - Month? How do i get the following: A1= 11/9/05 I want B2 to = "Nov" thanks, Ken -- sungen99 ------------------------------------------------------------------------ sungen99's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=9144 View this thread: http://www.excelforum.com/showthread.php?threadid=483614 Tag: excel forms Tag: 76974
  - 7
    - Document not saved Office 2003, Win XP sp 2 I have a large excel spreadsheet, and every once in a while when I try to save it, it states "document wont save". I have tried saving to different places, on the netowrk, local hd, etc. If I close it, and loose all my additions, it will usually work again for a while. Any reasons this would happen. Tag: excel forms Tag: 76968
  - 8
    - Networkdays I am having a problem with this formula in that it gives me 2 extra day sometimes and other times it works ou ok. Can anyone help me figure ou what I am missing. See my attachment for formula and sample data. Thanks +------------------------------------------------------------------- |Filename: Image1.jpg |Download: http://www.excelforum.com/attachment.php?postid=4020 +------------------------------------------------------------------- -- GORDO ----------------------------------------------------------------------- GORDON's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=616 View this thread: http://www.excelforum.com/showthread.php?threadid=48356 Tag: excel forms Tag: 76962
  - 9
    - Formatting decimal to show in a cell comment with VBA Can anyone help? This is my current code: Range("F11").Comment.Text Text:=" " & Range("F12") The F12 cell is define as a number with 2 decimal(i.e.: 4.60) If the number that is assign is 4.60 as an example, the result looking at the comment cell F11 is 4.6 the zero is always missing. Thank's ahead! Tag: excel forms Tag: 76961
  - 10
    - Calculate within cell I am using Excel 2003 for the PC. I want to be able to perform arithmetic on an existing cell value, e.g., A1 contains the value 45 and I wish to add other values to it. Typing the equal sign obliterates the original entry. Double clicking the cell might place the insertion point between numbers--this is awkward. Pressing F2 places the insertion point at the end of the value. This is also awkward because I must move the insertion point to the beginning of the value to place the equal sign. My Excel for 2004 for Mac has a calculator icon which when clicked automatically enters the initial value into an on-screen calcultor. Any suggestions as to how this might be efficiently done? Thanks, Stu B Tag: excel forms Tag: 76957
  - 11
    - 2003 Links When I open a ss in 2000 and say I don't want to update the links it shows the numerical data but if I open it in 2003 it shows Values instead can anyone help or explain why this happens. Tag: excel forms Tag: 76953
  - 12
    - Pivot tables- putting more than two field list item into the data Hello I am trying to put more than two fields into the data area. Firstly I dropped one field into the data area, then I dropped another field right on top of where it says "data" with the drop down item. When I try and drop further fields into onto the data area they end up either in the column or row fields. How do I get around this? Thankyou in advance Driver/Tim Tag: excel forms Tag: 76944
  - 13
    - Locking all Spreadsheets together Hi, I have many spreadsheets and I wish to lock all of them, it is very difficult for me going through all of them every time I need to change anything. Locking whole workbook doesnt let me use options i need to use. Is there any other easy way ? Tag: excel forms Tag: 76935
  - 14
    - How to Make macros work automatically on opening the worksheet Hi All, I have a worksheet which contains combox and textboxes i have written a macro to fill the comboboxes with values. My problem is this macro works only when i press F5 or if i select the macro and click on the run button. Is there a way to automatically run the macro on opening the worksheet. if so where/what code to be written to make this process run? Plz help me out -- sjayar ------------------------------------------------------------------------ sjayar's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28435 View this thread: http://www.excelforum.com/showthread.php?threadid=483427 Tag: excel forms Tag: 76933
  - 15
    - How to import a table on a Web page to Excel? Hello How to import a table on a Web page to Excel? Columns in the table are delimited by several spaces, not by a htm table tag. Tag: excel forms Tag: 76932
  - 16
    - Record Duplication & Formatting Advise Please..... I would be most appreciative if anyone could answer my questions below, thanks Dermot. I am looking for the best way to configure a column so that if I enter "yes" it enters "Yes".....or if I enter "y" it enters "Yes". At the moment I am using auto correct but I wondered if this is the correct use of this feature and whether or not there is a better way. I also looked at the "Proper " format, but can't seem to get it to work. Looking up the help feature doesn't help. The help example appears to be for one cell only I would like say all first names and second names to start with capitals. I can't seem to set this up. I end up with either the formula showing in one cell or a circular error. I don't think I have to format each cell individually in a column? How do I prevent individuals form entering "Duplicate" Rows (records) into my spread sheets ALL suggestions and any links to an example would be appreciated. Can you advise me what the "Easiest On The Eye" text formating to use in a spreadsheat? I have a few to tidy up and they are uncomfortable to view. I have formatted them to look reasonably good but would be interested in professional tips to improve them further.....any suggestions or links of any tchnical level would be appreciciated Any other suggestions how I can get to grips with the formatting ffeatures would be appreciated. Thanks agian for your time Dermot Tag: excel forms Tag: 76930
  - 17
    - Excel CRASHES when I try to save even a blank worksheet How can I fix this problem? Please help thanks Tag: excel forms Tag: 76926
  - 18
    - Compare lists I have two worksheets. I want to compare a list in sheet 2 with a value in sheet 1. If the value is found in the list, let's say in cell A1, I want to extract the content in cell A2 and paste it into a cell in sheet 1. Confusing?!! -- Nemesis Design is my life! ------------------------------------------------------------------------ Nemesis's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=5702 View this thread: http://www.excelforum.com/showthread.php?threadid=483399 Tag: excel forms Tag: 76925
  - 19
    - worksheets with in workssheets? I am trying to setup a class scheduling workbook. I want work sheets that represent weeks and then within that sheet have separate tabs for the days of the week...can this be done? ie I click on "week 1" tab and then I can select any of the days of the week and that gives me my list of classes for that day. Thanks Tag: excel forms Tag: 76923
  - 20
    - excel xp will not launch When I try to launch Excel 2002, nothing happens. Was working before, now not at all. Other Office Suite products work fine. Tried removing *.xlb files but no luck..Any suggestions appreciated. Tag: excel forms Tag: 76921
  - 21
    - Test Tag: excel forms Tag: 76913
  - 22
    - keyboard shortcut between worksheets? Can anyone tell me of a keyboard shortcut that would alternate me through the worksheets in an Excel workbook similar to the way ALT+TAB moves me through running applications? Thank you. Tag: excel forms Tag: 76912
  - 23
    - If & Then This is a tought one.......... I'm trying to make an IF function but don't know if what I want is possible. In F33 I have 185,000.00 (this number changes every month) If the user puts the correct verification code in F35 then L35 will say "OK", If not, L35 will say "Wrong Code" The problem is, to get the verification code on 185,000,00 one would count the amount of digits in the number and then add the value of the digits. 185,000.00 is eight digits long, so the calculation would be: 8+1+8+5+0+0+0+0+0 = 22 So the verification code would be 22. Is there such a formula in excel that could figure out the verification code? Thanks to anyone who can help me or who can tell me I'm crazy. Yosemite Tag: excel forms Tag: 76897
  - 24
    - multiple page fields in a pivot tanle I am trying to have a pivot table react to a change in this dropdown box. The user clicks on 2 groups of option buttons first but after the code gets to this line "pfTYPE.CurrentPage = strPI(1)", it won't go any further. This changes the first page field but won't go beyond this. What am I doing wrong ? Sub DropDown937_Change() Dim pt As PivotTable Dim pfTYPE As PivotField Dim pfRIM As PivotField Dim pfSIZE As PivotField Dim pi As PivotItem Dim strPI(1 To 3) As String Dim i As Integer Set pt = ActiveSheet.PivotTables(1) Set pfTYPE = pt.PivotFields("TYPE") Set pfRIM = pt.PivotFields("RIM") Set pfSIZE = pt.PivotFields("SIZE") Application.ScreenUpdating = False Range("X1").Select strPI(1) = ActiveCell Range("X2").Select strPI(2) = ActiveCell Range("X3").Select strPI(3) = ActiveCell pfTYPE.CurrentPage = strPI(1) pfRIM.CurrentPage = strPI(2) pfSIZE.CurrentPage = strPI(3) Range("A1").Select Application.ScreenUpdating = True End Sub Tag: excel forms Tag: 76895
  - 25
    - Same time, next year.... Hello, I am working on a massive (evil) Double-Declining Balance AMT spreadsheet...ugh! The first issue I would like to address is that I have a list of assets, all with different purchase dates in Column C. I would like column D to compute the date of 3/31/XX, where XX is the NEXT instance of the date 3/31. In other words, Date Entered Date Desired 8/17/05 3/31/06 2/15/87 3/31/87 6/24/94 3/31/95 I've worked with dates before and created a pretty intense timesheet, but I am at a loss as to where to begin for this particular concern...any thoughts? bobbie Tag: excel forms Tag: 76885
- Next
  - 1
    - Macro to filter and display only top 5 records on last sheet Hi I have a dump of records on excel that will look like this. Class VOL. Access 25 Excel 20 Word 50 Outlook 10 I want a macro to automatically pull out the records with top5 volumes from a large range, and paste it in descending order on a specific worksheet which is pre-formatted. Desired Result: Class VOL Word 50 Access 25 Excel 20 Outlook 10 Please advise on how I can do this. Cheers! Sunny Tag: excel forms Tag: 76881
  - 2
    - Preview doesn't work Does anyone know what to do when preview doesn't work when you are opening a file? It is set for preview but when I click on a file it says preview not available. Thanks, Tag: excel forms Tag: 76880
  - 3
    - Dont count weekends Todays date is x ok. Its easy to get yesterdays date by doing x-1. Bu if I only want to have WORKDAYS and I do x-2 (which by the way is doin a look up function and because there is no data for weekends) I get #N/A. How do I tell it to only use weekdays? Thank you in advance, Ke -- sungen9 ----------------------------------------------------------------------- sungen99's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=914 View this thread: http://www.excelforum.com/showthread.php?threadid=48329 Tag: excel forms Tag: 76872
  - 4
    - Sort on Protected Fields This is a multi-part message in MIME format. ------=_NextPart_000_000B_01C5E4A8.BB5DEA20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am trying to Sort on Protected Field and unprotected fields, I have a = spreadsheet that I have protected from users, but there is a need for = them to sort the data range. Because some of the fields are protected = the user gets an error when the macro is run to sort. Can anyone help ------=_NextPart_000_000B_01C5E4A8.BB5DEA20 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2769" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV> <P><FONT face=3DArial size=3D2>I am trying to Sort on Protected Field = and=20 unprotected fields, I have a spreadsheet that I have protected from = users, but=20 there is a need for them to sort the data range. Because some of the = fields are=20 protected the user gets an error when the macro is run to = sort.</FONT></P> <P><FONT face=3DArial size=3D2></FONT> </P> <P><FONT face=3DArial size=3D2>Can anyone = help</FONT></P></DIV></BODY></HTML> ------=_NextPart_000_000B_01C5E4A8.BB5DEA20-- Tag: excel forms Tag: 76862
  - 5
    - How should I do this? I am using Excel 2000 and have a problem. I have a spreadsheet from an associate that the tracks the purchasing of steel. MY PROBLEM: Currently he types in the steel thickness on column C on a sheet named 2005. He then looks a another page in the same workbook named Specification to match up the pounds per square foot. For example 1/4" = 10.21 lbs. per square foot. After he looks at the specification page and matches his steel thickness with the appropriate lbs. per sq. ft. he will put the answer (in this case) 10.210 in column D on the sheet named 2005. I would really like to create a formula or something that will let him type in whatever cell he may be at in column c and have the info. in that particular cell go to the chart on the Specification page and find the answer and put the answer in column D on the sheet named 2005. What would be the best way to accomplish this? Thanks to any and all who contribute! Tag: excel forms Tag: 76861
  - 6
    - Data Validation criteria I have a cell with data validation on it that refers to a dynamic name range. I would like to append the choice "New" to the list of vali entries. Is it possinle to do this as part of the data validation se up for the cell as opposed to adding this entry to the range on whic it is based -- blatha ----------------------------------------------------------------------- blatham's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1944 View this thread: http://www.excelforum.com/showthread.php?threadid=48327 Tag: excel forms Tag: 76859
  - 7
    - Common Data Items I have 4 columns of similar data. Can anyone suggest a neat method of creating a 5th column comprised only those data items that appear in each of the other 4? N.B. The data items' position in the columns is irrelevant so long as they appear somewhere in each of the 4. -- blatham ------------------------------------------------------------------------ blatham's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=19441 View this thread: http://www.excelforum.com/showthread.php?threadid=483272 Tag: excel forms Tag: 76858
  - 8
    - name a backup file I am trying to create a backup copy of a current spreadsheet, and I want to call it a backup copy and place the month in the title of the file. Can anyone help me achieve this. PR Tag: excel forms Tag: 76857
  - 9
    - Pivot tables- grouping a particular field Hello I'm pretty new to PTs and I'm having some difficulties. I a have database that needs summarising. The second column has all the dates up to the present using autofill. I wanted to summarise the data on the PT into a week e.g.1 07/11/2005-13/11/2005 but when I put the date field into the Pivot table I get each individual date rather than nice little groups e.g.2 <07/11/2005 07/11/2005-13/11/2005 14/11/2005-20/11/2005 >20/11/2005, etc, etc I know this can be resolved because someone I kindly received a pivot table from someone of one of these discussion boards in this form. Thank you in advance Tim/Driver Tag: excel forms Tag: 76856
  - 10
    - OT: Google groups problem I seem to have lost the ability to reply to any message that I have "starred" for tracking. If I open a recent message from the board, there is a "reply" option at the end, but not on any of the messages I have starred. It could be that the last message in the thread is mine, but I have replied to my own meesage before to clarify and it worked then. I'm stumped... Ideas? Thanks! PS: If I don't reply, your suggestion didn't work :) Tag: excel forms Tag: 76845
  - 11
    - removing "space" character Is there any built-in function that remove the character space? Tag: excel forms Tag: 76840
  - 12
    - Convert Quattro Pro 6 WB2 to XLS2003 Does anyone know if this can be done? We have a user that has a number of old Quattro pro files and we'd rather not reload this on her machine. TIA Tag: excel forms Tag: 76838
  - 13
    - Saving New Documents on a network Drive. Hiya. Whenever i make a new excel document and have to save it on our office network drive it says, "Cannot save Blank. This folder is read only." Only, the folderis NOT read only. All other software has no issues saving here but excel. any ideas? I'm sick of saving on the local drive and copying it over to the network drive. Thanks. Tag: excel forms Tag: 76835
  - 14
    - Hyperlink formatting I am trying to reformat hyperlinks and followed hyperlinks so that the font isn't underlined and a different colour. When I try to reformat the style for each of those, I get an Excel error that the formatting can't be changed on a protected sheet, --- but the sheet isn't protected! What am I missing? TIA David Tag: excel forms Tag: 76834
  - 15
    - Rounding Formula Is there a function that allows you to round a value up to the nearest multiple of 5? I tried the round up function, but I don't think that is going to work. I need to take the value of a cell (eg. 241 needs to rounded up to 245) and round up to the nearest multiple of 5. Any advise would be gretaly appreciated! -- puppypants ------------------------------------------------------------------------ puppypants's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28654 View this thread: http://www.excelforum.com/showthread.php?threadid=483177 Tag: excel forms Tag: 76831
  - 16
    - Formulas in Pivot based on average Hi I cannot get Pivot to calculate with amount in column, it sumarises from basesheet. I have 3 columns in base sheet: Costcenters (multiple times), cost element (only one pr. cost center), cost Then I use 2 vlookup's on costcenter to get an A&B allocation % (Total 100%) pr costcenter. This value I included in Pivot, but Pivot summed up the number of times. F.ex on 1 costcenter I had allocation 75% Then Pivot sumed up number of times 75% were looked up on that costcenter as costcenter appeard in many rows as linked to different costselements. I managed to use a max/average formula so now it actually shows right values in Pivot, but when I want to use THAT value to calculate with cost column in Pivot. But it stills calculate with the sum from original sheet and not the value in The column in Pivot. Cost Center; A; B; Costs; Sum of A (formula (costs*A); FA30202; 0,75; 0,25; 3 656 793; 137 129 724; I want the answer 2 742 594. But as you see the answer Pivot gives me is 137 129 724 Here Excel takes number of times 0,75 is in base sheet (50 costelements)=37,5 Somebody having a suggestion for this. Very greatfull if a solution exists Thanks :) -- Lillian Eik ------------------------------------------------------------------------ Lillian Eik's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24919 View this thread: http://www.excelforum.com/showthread.php?threadid=483178 Tag: excel forms Tag: 76830
  - 17
    - grouping by dates in pivottable Hi all, My dataset contains a column of start dates / times formatted as dd/mm/yyyy hh:mm I have created a pivot table with this field as the column headers. I would like to group all the data by Month and year so that my column headers would read: Jun 05 Jul 05 Aug 05 and then the data beneath these headings would be the total occurances in the month. I have done grouping in pivottables before but not with dates and I keep getting an error box saying "Cannot group selection". I am getting :mad: and :confused: trying to find out what the problem is cos I know that this can be done. Any help would be appreciated. Regards -- danlightbulb ------------------------------------------------------------------------ danlightbulb's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23433 View this thread: http://www.excelforum.com/showthread.php?threadid=483155 Tag: excel forms Tag: 76829
  - 18
    - double dropdown/combobox i have 8 offices with each 12 employees. in column A i want to select (with a combobox?/dropdown?) a certain office and then in column B appears a combobox/dropdown(?) with the 12 employees of that office. i know this is possible but i don't know how. maybe there is somebody out there who can help me. thanks very much for your help. regards arie Tag: excel forms Tag: 76807
  - 19
    - Absolute Cell Reference Across A Range Hi all, Can anyone tell if there is a means of setting a range of cells (fo example a1:c20) as absolute cell references without going into eac cell and F4-ing. I'm copying and pasting a bunch of tables where the whole table need to have absolute references, and it's a pain in the backside having t go through each cell and press F4! Any help would be greatly appreciated, Samuel -- Samuel ----------------------------------------------------------------------- SamuelT's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2750 View this thread: http://www.excelforum.com/showthread.php?threadid=48311 Tag: excel forms Tag: 76806
  - 20
    - Copy Across Worksheets Hello, I am trying to create a workbook that has a large number of worksheets, which I have created using VBA to correspond with days & dates. I am now trying to copy the data in the first worksheet to the other 150+ sheets so they have the same core, this works great until I start to create lists in the first sheet. I get this error "cannot make changes to a list or xml mapping when multiple sheets are selected" does anybody know how I can achieve this either by creating a macro that is activated when the sheet is selected to turn the list selection on or by copying it over. Any help would be greatly received. Many Thanks Glen Knight Tag: excel forms Tag: 76805
  - 21
    - Shock Horror Went into a cell and typed =Format(avalidDate,"ddd") expecting Mon or Tue or . . . . and it said ERROR! how then do I display a date as the day!!! Not an option that's displaying in the format date dialogue! I can hardly believe it almost as bad a s the day many years ago when I typed A1 + A2 at Lotus 123 and it failed because I'd put spaces each side of the + sign! Jim Bunton Tag: excel forms Tag: 76803
  - 22
    - Converting Hours into Days Hi, I have a number of task listed. For each task a certain number of hours have been assigned. The input of hours is done by Time(H,M,S) formula and formatted as [h]:mm:ss. After adding up the total hours for all the task, I would like to convert it into mandays. Is there any formula or method to do so. It is assumed that one manday/working day is of 8 hours. For eg. 96 hours 45 minutes is to be converted to 12.093 days. How do I convert with a formula since the hours are subject to change and hence I need the Mandays depending on the total hours. Regards Sandip. Tag: excel forms Tag: 76802
  - 23
    - Blocking fields to avoid use in formulas Is there any possibility to block the particular field in order to avoid users to use invalid fields in formulas ? regards Peter Tag: excel forms Tag: 76799
  - 24
    - COUNT and SUM Hello! I have: 10 100 25 50 ... I would like SUM and COUNT all values >20, for example. Thanks in advance. an Tag: excel forms Tag: 76793
  - 25
    - Highlight entire row Hi, I have a series of data alphanumeric in various columns from A2 to I125 (aaprox.). The same has many rows. I want that in cell B1 when I enter certain data (either numeric or alphanumeric or just words) the same should search in the data below (from A2 to I125) and highlight the rows (or the rows gets filled with certain colours) which has that data entered in B1. Cheers, Mandeep Tag: excel forms Tag: 76792

Can anyone tell me how you can get a text box to display a number in the
format 0.00 ?

Re: excel forms by Dave

Dave
Wed Nov 09 17:56:40 CST 2005

Dim myVal as double
myval = 3
textbox1.value = format(myval,"0.00")

Jim Lavery wrote:
>
> Can anyone tell me how you can get a text box to display a number in the
> format 0.00 ?

--

Dave Peterson

Top

Re: excel forms by dominicb

dominicb
Wed Nov 09 17:58:52 CST 2005

Good evning Jim Lavery

This code will show the value of 100 to two decimal places i
textbox1:

TextBox1.Value = Format(100, "#,###.00")

HTH

Dominic

--
dominic
-----------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1893
View this thread: http://www.excelforum.com/showthread.php?threadid=48370

Top