Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Chats
  • Order by date
  1. Chats

    Return specific list or library in office research pane

    I have followed instructions here [http://office.microsoft.com/en-us/help/HP010002811033.aspx], to connect the research pane in MS Word 2003 to a sharepoint site on my company intranet My problem is that this returns not just results from the specific sharepoint site I connect to, but to my...
  2. Chats

    Simulate tab order for form controls dropped into spreadsheet

    Fumei, The code responds to the keyup event and checks to see if the keycode of the keypress detected = 9 (tab key). If it does, the .activate on textbox 2 switches the cursor to textbox2 (from textbox1). I will then need a similar piece of code in textbox2 which switches the cursor to...
  3. Chats

    Simulate tab order for form controls dropped into spreadsheet

    Bingo - I have found a solution, here it is for anybody struggling with the same thing in the future. In this example, two textboxes (ActiveX version) embedded in a spreadsheet. Set the following code as an event for textbox1 Private Sub textbox1_KeyUp(ByVal KeyCode As MSForms.ReturnInteger...
  4. Chats

    Simulate tab order for form controls dropped into spreadsheet

    Thanks for responding so fast... I am using ActiveX textboxes, so can do something with the events, but I am not sure which event to use for this - if I click into a textbox in my "form" and then press the tab key, the cursor stays in the same text box, so this won't (I presume) trigger any of...
  5. Chats

    Simulate tab order for form controls dropped into spreadsheet

    I am trying to achieve the same thing discussed previously in thread707-602893 I have textbox objects dropped directly onto an Excel spreadsheet (i.e. not in a VBA form). I would like to provide the functionality for my users to tab between textbox fields on my spreadsheet. Because I have...
  6. Chats

    How to lookup a value in a 2 col table and find the nearest match?

    I hope somebody can help. I have a two column table in an Excel worksheet: Row LowVal HighVal 1 10 50 2 51 75 3 76 100 etc I have another list of values on another sheet in the same workbook like this: 25 58 61 etc I need some way...
  7. Chats

    Conditional number formatting

    This may be too simple and understanding of your problem, but as an alternative to using VBA, could you hide the z's column (lets call it column C on the spreadsheet), then in column D put a formula along the lines of: =IF(B2="a",TEXT(C2,"#.##"),TEXT(C2,"#.###")) Nested IF's would allow more...
  8. Chats

    Date changes from UK to US format when stored in cell

    Hi littlewoman, Thanks - this worked a treat. Ade
  9. Chats

    Date changes from UK to US format when stored in cell

    Hi, I have a simple userform with one textbox - InDate With the following code Private Sub InDate_Exit(ByVal Cancel As MSForms.ReturnBoolean) Worksheets("Sheet1").Range("A1") = InDate.Value End Sub If I enter 1/5/05 (UK format so 1 May 2005) into the InDate textbox, cell A1 on my...
  10. Chats

    How to add top values in a grid only until total = 80

    I think I have solved it! I post below my solution, hopefully it will be helpful to somebody else one day... I hope my description makes sense and allows the solution to be recreated: I have my 3x3 grid in range B3:D5. In cells F3 down to F11 I have the following formulas:-...
  11. Chats

    How to add top values in a grid only until total = 80

    Tim, Good questions:- Duplicate numbers would both be highlighted - so both cells with number 12 (R2C2 and R1C1 in your list) would be highlighted. I appreciate that this could potentially result in every cell in the table being highlighted if each one had, for example an identical value of 1...
  12. Chats

    How to add top values in a grid only until total = 80

    If anybody can suggest a way to tackle this problem I will be very happy: I have a table in Excel, to keep things simple for now, 3 rows by 3 columns (the actual table is bigger) - something like this: | C1 C2 C3 ============== R1 | 12 05 22 R2 | 06 16 03 R3 | 01 09 35 What I need to do...
  13. Chats

    Is there a more efficient way to filter values then populate listbox?

    I have set up a VBA userform in Excel 2000. The form has a multiselect 2 column listbox. A sheet called "Index" contains around 7000 rows of data in two columns - Code | Description There is a textbox on my form called SearchFor. I have written some code which responds to the change event on...
  14. Chats

    Listbox click event not working

    Partly answering my own question, the mousedown event seems to work ok even when mutliselect is chosen for the listbox. Seems odd situation though! Ade
  15. Chats

    Listbox click event not working

    Can somebody explain to me how the click event works on a listbox. I have a userform in Excel, with a listbox(Listbox1). When I run this test code, the msgbox is shown each time the listbox is clicked. However, when I set the listbox to multiselect, the msgbox is no longer shown. Private...
  16. Chats

    Why is this MyObject.setfocus not working?

    PH, Excellent, thanks! With a little bit of experimenting I now have the following code which works perfectly (and is a much neater way of doing things) Dim MyObject As Object Private Sub NumberOfFloors_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean) If TestNumeric(NumberOfFloors)...
  17. Chats

    Why is this MyObject.setfocus not working?

    Zameer, Thanks, but I just tried this - my new code looks like this Dim MyObject As Object Private Sub NumberOfFloors_Exit(ByVal Cancel As MSForms.ReturnBoolean) Set MyObject = NumberOfFloors Call TestNumeric(MyObject) End Sub Private Sub TestNumeric(Object) If Object.Value <>...
  18. Chats

    Why is this MyObject.setfocus not working?

    Hi, I have the following code which sits behind a userform in Excel VBA. What I want is that when the user clicks or tabs out of a textbox, the TestNumeric procedure is called, which checks to see if the values are numeric. If not, a messagebox is produced and the cursor focus is sent back to...
  19. Chats

    Refreshing shape colors in Visio 2002 from a database?

    John, Thanks - I will use VBA. I have a fair amount of experience of VBA in Excel / Access, but none in Visio. Its a beginners question, but could you suggest a code line which would do the equivalent of "refresh shape properties" from the right click menu (after database connection has been...
  20. Chats

    Refreshing shape colors in Visio 2002 from a database?

    I found this thread while searching the archives for a problem I am working on. This has got me a fair way to where I want to be - but AricWentz's final question was never answered - and I really need to know the answer to this myself now. Is there a way of refreshing the properties of...

Part and Inventory Search

Back
Top