Recent content by Chats

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...

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...

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...

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...

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...

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...

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...

Hi littlewoman, Thanks - this worked a treat. Ade

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...

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:-...

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...

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...

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...

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

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...