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

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

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

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

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

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

Hi, I am trying to set up some code which will use a listbox (multiselect) to populate a textbox. A second bit of code runs when the userform opens, checks the contents of the textbox to see what has been previously entered, and sets the .selected property on the listbox entries to match. This...

Sorry if this is a daft question... To sum the values stored in an array, I currently use a For...Next loop. I can't help but think there must be a smarter and better way? I am using Excel 2000. Thanks for any better suggestions! Ade Private Sub test() Dim abc(0 To 2) As Integer Dim...

I have some VBA code with a userform. When the user clicks out of a particular field on the form, I want to run some validation code, and if the entry is invalid, shade the box, show a message and then return the cursor to the textbox. I have pasted my code below (cut down to keep things simple...

I have some VBA code with a userform. When the user clicks out of a particular field on the form, I want to run some validation code, and if the entry is invalid, shade the box, show a message and then return the cursor to the textbox. I have pasted my code below (cut down to keep things simple...

Hi, I have a series pie charts created using pivot charts in Excel 2000 with page fields set up to allow the user to select which categories of data to show on the chart. I have changed the chart's formatting to include data labels on the pie chart. When the user chooses an option from the...

Hi, I have a Word (2000) document in which checkbox controls have been dropped directly into the document from the "control toolbox" toolbar to make a form. This is to allow users to complete the form and send it back via e-mail. Using the control toolbox toolbar I exit design mode and save...

With the help of this forum I am using ADO to send data from Excel 2000 to Access 2000 using some VB in Excel. Everything works fine. I now have a slightly different need - before I send the data I need to check if the record already exists in Access - to avoid getting duplicates each time the...

I have an Excel (2000) spreadsheet containing data which has been entered without any validation. I have created an ADO export sub procedure in VBA to send this data across to an Access(2000) table. Everything works fine, until the sub procedure encounters an item of data in Excel which does...

Hi, I am trying to set up a spreasheet where there are five values (range B2:B5) the values of which can be manipulated using some kind of slider control, but with a rule that sum(B2:B5) is always 100. This is to allow the user to give relative weightings to different items, on a percentage...

In Access (2000), I want to populate a combo box based on the value of another field on the same form. For example, if I have a field called "World Region" and another called "Country", when I select Region = Europe I want the Country combo box to list countries in Europe Region = Africa I...

Hi, I have a spreadsheet in Excel 2000. I want to allow the users to access the spreadsheet to use autofilter & view records, but if the user tried to make any changes to the data, they are blocked from doing so and told to use the userform instead. This is to control the quality of data input...

Hi, I'm using Excel 2000. I have a speadsheet which has a table of data 3 columns wide (CODE, DESCRIPTION, CATEGORY). What I want to do is have the user to use autofilter on the CATEGORY column, and then to use VBA to populate the items of a combobox using ONLY the visible values from the...