Search results for query: *

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

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

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

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

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

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