How to fill a combo box with choice from another combo box

I am trying to fill combo box with a choice made in another combo box.

I am trying to select a choice from a combo box "Customer_11" and then have 
the following choices available in another combo box "State_11". Below is the 
code I was trying to use, but not having any luck with getting it to work. 


'=====================================================
    'CES Customer Information
        With Me.Customer_11
            .AddItem "Customer 1"
            .AddItem "Customer 2"
            .AddItem "Customer 3"
            .AddItem "Customer 4"
            .AddItem "Customer 5"
            .AddItem "Customer 6"
            .AddItem "Customer 7"
        End With
'=====================================================




'************************************************************
'Auto Fill Customer Information
'************************************************************
Private Sub Customer_11_Change()

  Select Case Customer_11
     
    Case "Customer 1"
        State_11 = "FL"
        State_11 = "GA"
        State_11 = "AL"
        State_11 = "TN"
        State_11 = "KY"
        State_11 = "NC"
        State_11 = "SC"
        State_11 = "MS"
        State_11 = "LA"

    End Select
End Sub
0
Utf
4/20/2010 4:51:01 AM
excel.programming 6508 articles. 2 followers. Follow

7 Replies
743 Views

Similar Articles

[PageSpeed] 16

I think this is what you want:
http://www.contextures.com/xlDataval02.html

http://www.contextures.com/xlDataVal13.html



-- 
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Brian" wrote:

> I am trying to fill combo box with a choice made in another combo box.
> 
> I am trying to select a choice from a combo box "Customer_11" and then have 
> the following choices available in another combo box "State_11". Below is the 
> code I was trying to use, but not having any luck with getting it to work. 
> 
> 
> '=====================================================
>     'CES Customer Information
>         With Me.Customer_11
>             .AddItem "Customer 1"
>             .AddItem "Customer 2"
>             .AddItem "Customer 3"
>             .AddItem "Customer 4"
>             .AddItem "Customer 5"
>             .AddItem "Customer 6"
>             .AddItem "Customer 7"
>         End With
> '=====================================================
> 
> 
> 
> 
> '************************************************************
> 'Auto Fill Customer Information
> '************************************************************
> Private Sub Customer_11_Change()
> 
>   Select Case Customer_11
>      
>     Case "Customer 1"
>         State_11 = "FL"
>         State_11 = "GA"
>         State_11 = "AL"
>         State_11 = "TN"
>         State_11 = "KY"
>         State_11 = "NC"
>         State_11 = "SC"
>         State_11 = "MS"
>         State_11 = "LA"
> 
>     End Select
> End Sub
0
Utf
4/20/2010 5:20:01 AM
That is for Combo Boxes on a worksheet. I am trying to do this on a User Form.

"ryguy7272" wrote:

> I think this is what you want:
> http://www.contextures.com/xlDataval02.html
> 
> http://www.contextures.com/xlDataVal13.html
> 
> 
> 
> -- 
> Ryan---
> If this information was helpful, please indicate this by clicking ''Yes''.
> 
> 
> "Brian" wrote:
> 
> > I am trying to fill combo box with a choice made in another combo box.
> > 
> > I am trying to select a choice from a combo box "Customer_11" and then have 
> > the following choices available in another combo box "State_11". Below is the 
> > code I was trying to use, but not having any luck with getting it to work. 
> > 
> > 
> > '=====================================================
> >     'CES Customer Information
> >         With Me.Customer_11
> >             .AddItem "Customer 1"
> >             .AddItem "Customer 2"
> >             .AddItem "Customer 3"
> >             .AddItem "Customer 4"
> >             .AddItem "Customer 5"
> >             .AddItem "Customer 6"
> >             .AddItem "Customer 7"
> >         End With
> > '=====================================================
> > 
> > 
> > 
> > 
> > '************************************************************
> > 'Auto Fill Customer Information
> > '************************************************************
> > Private Sub Customer_11_Change()
> > 
> >   Select Case Customer_11
> >      
> >     Case "Customer 1"
> >         State_11 = "FL"
> >         State_11 = "GA"
> >         State_11 = "AL"
> >         State_11 = "TN"
> >         State_11 = "KY"
> >         State_11 = "NC"
> >         State_11 = "SC"
> >         State_11 = "MS"
> >         State_11 = "LA"
> > 
> >     End Select
> > End Sub
0
Utf
4/20/2010 5:38:01 AM
Brian

You need to Add the items to the State combo.as below..

Private Sub CommandButton1_Click()
        With Me.customer_11
            .AddItem "Customer 1"
            .AddItem "Customer 2"
            .AddItem "Customer 3"
            .AddItem "Customer 4"
            .AddItem "Customer 5"
            .AddItem "Customer 6"
            .AddItem "Customer 7"
        End With

End Sub
Private Sub Customer_11_Change()

state_11.Clear
  Select Case customer_11
    Case "Customer 1"
        state_11.AddItem "FL"
        state_11.AddItem "GA"
        state_11.AddItem "AL"
        state_11.AddItem "TN"
        state_11.AddItem "KY"
        state_11.AddItem "NC"
        state_11.AddItem "SC"
        state_11.AddItem "MS"
        state_11.AddItem "LA"
    End Select
End Sub



-- 
Jacob (MVP - Excel)


"Brian" wrote:

> I am trying to fill combo box with a choice made in another combo box.
> 
> I am trying to select a choice from a combo box "Customer_11" and then have 
> the following choices available in another combo box "State_11". Below is the 
> code I was trying to use, but not having any luck with getting it to work. 
> 
> 
> '=====================================================
>     'CES Customer Information
>         With Me.Customer_11
>             .AddItem "Customer 1"
>             .AddItem "Customer 2"
>             .AddItem "Customer 3"
>             .AddItem "Customer 4"
>             .AddItem "Customer 5"
>             .AddItem "Customer 6"
>             .AddItem "Customer 7"
>         End With
> '=====================================================
> 
> 
> 
> 
> '************************************************************
> 'Auto Fill Customer Information
> '************************************************************
> Private Sub Customer_11_Change()
> 
>   Select Case Customer_11
>      
>     Case "Customer 1"
>         State_11 = "FL"
>         State_11 = "GA"
>         State_11 = "AL"
>         State_11 = "TN"
>         State_11 = "KY"
>         State_11 = "NC"
>         State_11 = "SC"
>         State_11 = "MS"
>         State_11 = "LA"
> 
>     End Select
> End Sub
0
Utf
4/20/2010 5:41:01 AM
I pasted the code exactly as you have it. but I can't get anything to show up 
in the 2nd Combo Box "State_11". 

Everything works great on the 1st Combo Box "Customer_11", but I can't get 
anything to show up in the 2nd Combo Box "State_11". What did I do wrong? 


"Jacob Skaria" wrote:

> Brian
> 
> You need to Add the items to the State combo.as below..
> 
> Private Sub CommandButton1_Click()
>         With Me.customer_11
>             .AddItem "Customer 1"
>             .AddItem "Customer 2"
>             .AddItem "Customer 3"
>             .AddItem "Customer 4"
>             .AddItem "Customer 5"
>             .AddItem "Customer 6"
>             .AddItem "Customer 7"
>         End With
> 
> End Sub
> Private Sub Customer_11_Change()
> 
> state_11.Clear
>   Select Case customer_11
>     Case "Customer 1"
>         state_11.AddItem "FL"
>         state_11.AddItem "GA"
>         state_11.AddItem "AL"
>         state_11.AddItem "TN"
>         state_11.AddItem "KY"
>         state_11.AddItem "NC"
>         state_11.AddItem "SC"
>         state_11.AddItem "MS"
>         state_11.AddItem "LA"
>     End Select
> End Sub
> 
> 
> 
> -- 
> Jacob (MVP - Excel)
> 
> 
> "Brian" wrote:
> 
> > I am trying to fill combo box with a choice made in another combo box.
> > 
> > I am trying to select a choice from a combo box "Customer_11" and then have 
> > the following choices available in another combo box "State_11". Below is the 
> > code I was trying to use, but not having any luck with getting it to work. 
> > 
> > 
> > '=====================================================
> >     'CES Customer Information
> >         With Me.Customer_11
> >             .AddItem "Customer 1"
> >             .AddItem "Customer 2"
> >             .AddItem "Customer 3"
> >             .AddItem "Customer 4"
> >             .AddItem "Customer 5"
> >             .AddItem "Customer 6"
> >             .AddItem "Customer 7"
> >         End With
> > '=====================================================
> > 
> > 
> > 
> > 
> > '************************************************************
> > 'Auto Fill Customer Information
> > '************************************************************
> > Private Sub Customer_11_Change()
> > 
> >   Select Case Customer_11
> >      
> >     Case "Customer 1"
> >         State_11 = "FL"
> >         State_11 = "GA"
> >         State_11 = "AL"
> >         State_11 = "TN"
> >         State_11 = "KY"
> >         State_11 = "NC"
> >         State_11 = "SC"
> >         State_11 = "MS"
> >         State_11 = "LA"
> > 
> >     End Select
> > End Sub
0
Utf
4/20/2010 6:31:01 AM
Private Sub UserForm_Initialize()
        With Me.customer_11
            .AddItem "Customer 1"
            .AddItem "Customer 2"
            .AddItem "Customer 3"
            .AddItem "Customer 4"
            .AddItem "Customer 5"
            .AddItem "Customer 6"
            .AddItem "Customer 7"
        End With

End Sub
----------------------------------------------------------------------------

 Private Sub Customer_11_Change()
 
 state_11.Clear
   Select Case customer_11
     Case "Customer 1"
         state_11.AddItem "FL"
         state_11.AddItem "GA"
         state_11.AddItem "AL"
         state_11.AddItem "TN"
         state_11.AddItem "KY"
         state_11.AddItem "NC"
         state_11.AddItem "SC"
         state_11.AddItem "MS"
         state_11.AddItem "LA"
     End Select
 End Sub






"Jacob Skaria" wrote:

> Brian
> 
> You need to Add the items to the State combo.as below..
> 
> Private Sub CommandButton1_Click()
>         With Me.customer_11
>             .AddItem "Customer 1"
>             .AddItem "Customer 2"
>             .AddItem "Customer 3"
>             .AddItem "Customer 4"
>             .AddItem "Customer 5"
>             .AddItem "Customer 6"
>             .AddItem "Customer 7"
>         End With
> 
> End Sub
> Private Sub Customer_11_Change()
> 
> state_11.Clear
>   Select Case customer_11
>     Case "Customer 1"
>         state_11.AddItem "FL"
>         state_11.AddItem "GA"
>         state_11.AddItem "AL"
>         state_11.AddItem "TN"
>         state_11.AddItem "KY"
>         state_11.AddItem "NC"
>         state_11.AddItem "SC"
>         state_11.AddItem "MS"
>         state_11.AddItem "LA"
>     End Select
> End Sub
> 
> 
> 
> -- 
> Jacob (MVP - Excel)
> 
> 
> "Brian" wrote:
> 
> > I am trying to fill combo box with a choice made in another combo box.
> > 
> > I am trying to select a choice from a combo box "Customer_11" and then have 
> > the following choices available in another combo box "State_11". Below is the 
> > code I was trying to use, but not having any luck with getting it to work. 
> > 
> > 
> > '=====================================================
> >     'CES Customer Information
> >         With Me.Customer_11
> >             .AddItem "Customer 1"
> >             .AddItem "Customer 2"
> >             .AddItem "Customer 3"
> >             .AddItem "Customer 4"
> >             .AddItem "Customer 5"
> >             .AddItem "Customer 6"
> >             .AddItem "Customer 7"
> >         End With
> > '=====================================================
> > 
> > 
> > 
> > 
> > '************************************************************
> > 'Auto Fill Customer Information
> > '************************************************************
> > Private Sub Customer_11_Change()
> > 
> >   Select Case Customer_11
> >      
> >     Case "Customer 1"
> >         State_11 = "FL"
> >         State_11 = "GA"
> >         State_11 = "AL"
> >         State_11 = "TN"
> >         State_11 = "KY"
> >         State_11 = "NC"
> >         State_11 = "SC"
> >         State_11 = "MS"
> >         State_11 = "LA"
> > 
> >     End Select
> > End Sub
0
Utf
4/20/2010 6:33:01 AM
Instead of updating the 1st combo during Form initialize; I used a command 
button click event...

-- 
Jacob (MVP - Excel)


"Brian" wrote:

> Private Sub UserForm_Initialize()
>         With Me.customer_11
>             .AddItem "Customer 1"
>             .AddItem "Customer 2"
>             .AddItem "Customer 3"
>             .AddItem "Customer 4"
>             .AddItem "Customer 5"
>             .AddItem "Customer 6"
>             .AddItem "Customer 7"
>         End With
> 
> End Sub
> ----------------------------------------------------------------------------
> 
>  Private Sub Customer_11_Change()
>  
>  state_11.Clear
>    Select Case customer_11
>      Case "Customer 1"
>          state_11.AddItem "FL"
>          state_11.AddItem "GA"
>          state_11.AddItem "AL"
>          state_11.AddItem "TN"
>          state_11.AddItem "KY"
>          state_11.AddItem "NC"
>          state_11.AddItem "SC"
>          state_11.AddItem "MS"
>          state_11.AddItem "LA"
>      End Select
>  End Sub
> 
> 
> 
> 
> 
> 
> "Jacob Skaria" wrote:
> 
> > Brian
> > 
> > You need to Add the items to the State combo.as below..
> > 
> > Private Sub CommandButton1_Click()
> >         With Me.customer_11
> >             .AddItem "Customer 1"
> >             .AddItem "Customer 2"
> >             .AddItem "Customer 3"
> >             .AddItem "Customer 4"
> >             .AddItem "Customer 5"
> >             .AddItem "Customer 6"
> >             .AddItem "Customer 7"
> >         End With
> > 
> > End Sub
> > Private Sub Customer_11_Change()
> > 
> > state_11.Clear
> >   Select Case customer_11
> >     Case "Customer 1"
> >         state_11.AddItem "FL"
> >         state_11.AddItem "GA"
> >         state_11.AddItem "AL"
> >         state_11.AddItem "TN"
> >         state_11.AddItem "KY"
> >         state_11.AddItem "NC"
> >         state_11.AddItem "SC"
> >         state_11.AddItem "MS"
> >         state_11.AddItem "LA"
> >     End Select
> > End Sub
> > 
> > 
> > 
> > -- 
> > Jacob (MVP - Excel)
> > 
> > 
> > "Brian" wrote:
> > 
> > > I am trying to fill combo box with a choice made in another combo box.
> > > 
> > > I am trying to select a choice from a combo box "Customer_11" and then have 
> > > the following choices available in another combo box "State_11". Below is the 
> > > code I was trying to use, but not having any luck with getting it to work. 
> > > 
> > > 
> > > '=====================================================
> > >     'CES Customer Information
> > >         With Me.Customer_11
> > >             .AddItem "Customer 1"
> > >             .AddItem "Customer 2"
> > >             .AddItem "Customer 3"
> > >             .AddItem "Customer 4"
> > >             .AddItem "Customer 5"
> > >             .AddItem "Customer 6"
> > >             .AddItem "Customer 7"
> > >         End With
> > > '=====================================================
> > > 
> > > 
> > > 
> > > 
> > > '************************************************************
> > > 'Auto Fill Customer Information
> > > '************************************************************
> > > Private Sub Customer_11_Change()
> > > 
> > >   Select Case Customer_11
> > >      
> > >     Case "Customer 1"
> > >         State_11 = "FL"
> > >         State_11 = "GA"
> > >         State_11 = "AL"
> > >         State_11 = "TN"
> > >         State_11 = "KY"
> > >         State_11 = "NC"
> > >         State_11 = "SC"
> > >         State_11 = "MS"
> > >         State_11 = "LA"
> > > 
> > >     End Select
> > > End Sub
0
Utf
4/20/2010 7:01:01 AM
http://www.ozgrid.com/VBA/dependent-combobox.htm



-- 
Regards
Dave Hawley
www.ozgrid.com
"Brian" <Brian@discussions.microsoft.com> wrote in message 
news:597759FD-4B1E-4A15-94D2-23BF62210DA4@microsoft.com...
>I am trying to fill combo box with a choice made in another combo box.
>
> I am trying to select a choice from a combo box "Customer_11" and then 
> have
> the following choices available in another combo box "State_11". Below is 
> the
> code I was trying to use, but not having any luck with getting it to work.
>
>
> '=====================================================
>    'CES Customer Information
>        With Me.Customer_11
>            .AddItem "Customer 1"
>            .AddItem "Customer 2"
>            .AddItem "Customer 3"
>            .AddItem "Customer 4"
>            .AddItem "Customer 5"
>            .AddItem "Customer 6"
>            .AddItem "Customer 7"
>        End With
> '=====================================================
>
>
>
>
> '************************************************************
> 'Auto Fill Customer Information
> '************************************************************
> Private Sub Customer_11_Change()
>
>  Select Case Customer_11
>
>    Case "Customer 1"
>        State_11 = "FL"
>        State_11 = "GA"
>        State_11 = "AL"
>        State_11 = "TN"
>        State_11 = "KY"
>        State_11 = "NC"
>        State_11 = "SC"
>        State_11 = "MS"
>        State_11 = "LA"
>
>    End Select
> End Sub 

0
ozgrid
4/20/2010 8:14:01 AM
Reply:

Similar Artilces:

Conditional Formating based on another cell
I have 2 columns of concern DATE and COST. I would like the COST cell to be shaded if the DATE cell is less than a specificed date. Then if it is possible to calculate the COST field but only the ones highlighted. Help is greatly appreciated!! Thanks, Stacey For the conditional format, use the following for the condition of the cost column: =$A$2<TODAY() and so on, where cell A2 is the corresponding date column. Select the appropriate shade on the pattern tab. As far as calculating the cost column if it is highlighted, my only thoughts are to write a macro that you can run that c...

keyboard shortcut to go to search box in datasheet
What's the keyboard shortcut to jump to the search box at the bottom of datasheet? On Sun, 28 Mar 2010 21:02:07 -0700 (PDT), Song <song.usa@gmail.com> wrote: There is no search box at the bottom of a datasheet. What are you referring to? There is a record selector... Ctrl+F gets you to the Search box. Will that do? -Tom. Microsoft Access MVP >What's the keyboard shortcut to jump to the search box at the bottom >of datasheet? On Mar 28, 9:10=A0pm, Tom van Stiphout <tom7744.no.s...@cox.net> wrote: > On Sun, 28 Mar 2010 21:02:07 -0700 (PDT), ...

Can't delete from 'in box'.
When I try to delete an item from my in box it only does a strikeout leaving the item in place but with a line through it. I've looked through all of the options but can't see where this problem is addressed. Any help is appreciated. Sheryl Hilary Smith <zaqvhehx@yahoo.com> wrote: > When I try to delete an item from my in box it only does a strikeout > leaving the item in place but with a line through it. I've looked > through all of the options but can't see where this problem is > addressed. It's not a problem. It's how IMAP accounts work...

backing up 2001 to CD and transfering data to another machine with 2002
I want to back up my money 2001 data on a CD-RW and copy it on another machine with money 2002. How do I do that? In microsoft.public.money, Ed wrote: >I want to back up my money 2001 data on a CD-RW and copy >it on another machine with money 2002. How do I do that? See FAQ available at http://www.bollar.org/msmoney/ for information. ...

Purchased another company: Need to quickly get addr books merged
I'm hoping that someone has had a similar problem and could provide advice on the quickets/easiest way to handle this. My company just purchased another. We currently have our own forest with 2 Exchange2k3 servers, the new company has their own forest with ~6 exchange 2k3 servers and 2 5.5 servers. Short term the goal is to get email interoperable between the two internally (i.e not traversing the internet) along with addr book replication. Any suggestions as to how to accomplish this goal. This will be my first time trying to attach 2 forests to each other and then having exchange pull...

formula needed to extract data from another file
Hi, is there any possibility to do the following: e.g: in file program.xls, cell A1 I enter: 4788 in c:\My Documents\data folder there are many files, also file 4788.xls I need a formula in program.xls, cell A2 which looks up the value of cell D5 in file 4788.xls Next time I will enter e.g. 3578 into A1 and the formula must then give back the entry of D5 in file 3578.xls Hope I made myself understandable. Regards, Norbert On May 15, 2:09=A0pm, Norbert <n.jae...@gmx.net> wrote: > Hi, > is there any possibility to do the following: > > e.g: in ...

Combo box query (slighlty complicated)
Greetings, Bare with me on my explanation, its kinda tricky. The user would like ONE screen to add and edit information. The screen is as follows :- Main form (source is the tblModule) Module Name Module ID Archive (checkbox) 2 Subforms selecting data based on the Module ID. FOUR navigation buttons FIRST, LAST, NEXT and PREVIOUS. NEXT button will add a record (if at the end of the recordset). EDIT they can simply overtype information and use the NEXT button for the changes to be saved. However if there are 200 modules and they simply one to edit some data they would currently have to...

Restricted Access Mode check box not visible on user setup screen
I am in the middle of doing my first install and implementation of CRM 4.0 and have run into something I haven't seen before. When I open the User in the Settings|Administration area the user does not show a check box for the "Restricted Access Mode". Does anyone know why it isn't showing up? I have a test install at another client where I migrated from CRM 3.0 to 4.0 (in a test environment) and the check box is there, but on the new install at the other client, no check box. Any ideas? Al Pemberton allen@pembcons.com In CRM 4.0 you have the picklist "Access Mode&q...

paste formula from another file
I generated the formula in CSV. I'd like to copy these cells to an existing spreadsheet as whatever in the text. Excel keeps changing the reference cells. How can I paste it the formula as is? Thanks, Also, can you do search and replace on formulas? thanks! "cpliu" <spamfreeliu@yahoo.com> wrote in message news:a7da20ba-a44c-4224-9889-b58394de310e@a42g2000vbl.googlegroups.com... >I generated the formula in CSV. I'd like to copy these cells to an > existing spreadsheet as whatever in the text. Excel keeps changing the > reference cells. How can I paste it t...

Quoted "word" in combo RowSource
In the RowSource of a combo box that uses fixed text strings per line, how does one specify a quoted word? Example: "Line 1";"Line 2";"I want to have a quoted "word" here" I've tried """word""" and "I want to have a quoted" & """word""" & "here" I didn't try to set the line in code at runtime, as it would seem to me that with my last example that would probably be a waste of time? For the time being, I used two single quotes with success and the desi...

how do I make a box plot using excel
is there a way to get the data analysis plus tool pack on the 2003 version of excel. I'm trying to make a box plot, and I have used that on other computers There are instructions here for loading the Analysis Toolpak: http://office.microsoft.com/en-us/assistance/HP011277241033.aspx Also, Jon Peltier has instructions for creating Box and Whisker plots: http://www.peltiertech.com/Excel/Charts/ComboCharts.html#BoxWhisker opher32@hotmail.com wrote: > is there a way to get the data analysis plus tool pack on the 2003 version of > excel. I'm trying to make a box plot...

Form Subform Combo box
I want to design a form and on the form I will have a list box with 5 selections, selections 1-5. Each one these selections corresponds to a table of the same name. On my main form if I select one of these selections from my list box, I want my subform to display the corresponding table. Can someone get me started on this? Thanks, Sean First, realize there is a difference between a subform control on a form and the form being used as the subform. The subform control has a property named Source Object. It contains the name of the subform to load. You will need to create a form f...

Importing from another workbook
Advice please! We have a file held on a groupdrive that's accessible to all via our portal. On that workbook I want to add a sheet to show data pulled from a sheet in another workbook that's on a different server. That other workbook is refreshed daily, and so the new sheet needs to be easy to refresh. Furthermore, the import should only pull a few of the fields and needs to filter out certain records. Initially I thought about macroing to open the other workbook, copying the entire worksheet, and pasting into the first before chopping and filtering down the data. That should be ...

Why won't a hyperlink in a text box work when I PDF it?
I am trying to create a hyperlink in a newsletter and it is sitting in a text box. When I got to PDF the document, all the links work except for the one in the text box. What can I do to fix this? What version of Word are you using? What are you using to make the pdf? Pam Kat wrote: >I am trying to create a hyperlink in a newsletter and it is sitting in a text >box. When I got to PDF the document, all the links work except for the one in >the text box. What can I do to fix this? -- Message posted via http://www.officekb.com ...

Removing file names that are stored in open file box?
When you use open/file and then type in the file name it is stored in a drop-down list. How do you clear this list? hi, Gary ! > When you use open/file and then type in the file name it is stored in a drop-down list. > How do you clear this list? you need to look within the windows registry editor... HKCU\Software\Microsoft\Office\<version>\Common\Open Fnd\Microsoft <Office> Excel\Settings\Open\File Name MRU regards, hector. ...

Linking a one Presentation to Another Presentation
I have several presentations that are linked to my main presentation so when you click a link the secondary presentation opens up. My problem is that everytime I click a link that new presentation opens, which is good, but it doesn't close when I link back to the "home page". Is it possible to have a presentation close when you click the link back to the home page? This sounds like a PowerPoint question? On Mar 17, 8:49=A0am, ElizabethS <Elizabe...@discussions.microsoft.com> wrote: > I have several presentations that are linked to my main presentation so...

LINKS TO TEXT BOXES
I need to link a cell to a text box to continually update the text. Is this possible? The text box is used on an imported tiff photo. Hi Use a textbox from the Drawing toolbar. Select it when done and enter =A1 (or whichever single cell address) in the standard Excel formula field above the sheet. -- HTH. Best wishes Harald Followup to newsgroup only please "semar" <dsemar@kcwa.com> skrev i melding news:713044C6-34B2-4E12-AA51-9E69CC2E0D06@microsoft.com... > I need to link a cell to a text box to continually update the text. Is this possible? The text box is used on ...

How can I set up my report to fill more of the same page
Basically I have a report that bring up information but it only takes up the width of half the page, when I use report it only adds say 6 sets of information down the page before it runs out of room but it could fit another 6 alongside them. Is it possible to make it fill the page out in say 2 columns so before it goes to a new page after 6 it would actually fit 12 on the page in two columns of 6? Thank You :o) -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200705/1 Set up you report In design view, -- select Page Setup from the file m...

Choice of Data system
Hi, I'm a student and I'm currently developping a backup application in MFC (C++). My app basically consists of a Treeview and a listview control which holds all the files I want to back up and the ones that have already been backedup. My problem : which is the best solution for saving my data (treeview structure with files info ...). I think that loading the whole tree structure (and file list and info...) would take too much memory. I thought of using a database to store all my data. What do you think ? I need to be able to quiclky search for data, for example when the user select...

Find record in a table using combo box.
Hi , Please help. I am trying to create a form containing a Combo Box. This combo box has a list of Names. When user try to click one name and click the OK buttion, it should be able to generate the report. I can't successfuly link the value of the combo box with the query that I have created. When I ran the form with the combo box that has already the list of names, it can't display or generate the report. Please kindly help/assist if any one knows about the approach. thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/2007...

Setting a Cell's Value Based on Another Cells Contents
I can't imagine that this is as hard as I'm making it... but admittedl I am having some trouble, so here's my post....... I have two columns, the first (D) is titled Job Specialty Area an contains a dropdown list of 30 job types including one for "Other Jo Specialty Area". The other column is (E) and titled "Or Other..." , an allows the user to type in their own job specialty area (instead o choosing one from the list). The goal, if a user starts typing in column E, to default column D t "Other Job Specialty Area...." ANY ideas, comments, suggestio...

How do I get rid of the box showing 'fill down' options after I f.
How do I get rid of the box showing 'fill down' options after I fill down....and I mean permanently...so I never have to see it again? On the Tools menu, click Options. On the Edit tab, clear the Show Paste Options buttons check box to never again see the Show Paste Options button on the worksheet. (Unless you go back and check it again, of course!) "Lexcellulose" wrote: > How do I get rid of the box showing 'fill down' options after I fill > down....and I mean permanently...so I never have to see it again? Thank You BoniM...it worked!! "BoniM&...

Moving the Mail Store to Another Drive
I have SBS 2003 running Exchange 2003 and have now run out of space on the C drive. I want to maove the entire mail store to the E drive to free up space. Can and how is this done. Can't seem to find an article that addresses it. Thanks... Go to the properties of the Mailbox Store, then the Databases tab. Click Browse and select the new location for the edb and stm files. Once you select ok, it will take care of dismounting the store, moving it, the re-mounting the store. http://support.microsoft.com/?kbid=257184 -- Ben Winzenz Exchange MVP MessageOne "Ken Anderson"...

Changing the 'view' in the Outlook 'Regarding' box
I have been asked if it is possible to change the width for the 'name' column when setting an email to regard an opportunity. It's a bit narrow at present. I've looked in all the usual places and cannot find anything. Any help much appreciated. Regards Alan ...

Tranferring email files form one PC to another
I realize that this question has been asked a thousand times before and I should have paid attention. . I have copied all the files with the *dbx extension to a memory stick. How do I get them from there into the Local Folders of the new PC. TIA, Hagen Sahm Assuming this is OE to OE? Did you include Folders.dbx? If yes: Backup & Restore: http://www.insideoe.com/backup/ Backing up and Cloning your OE Identities: http://www.insideoe.com/backup/clone.htm If you did not include Folders.dbx, you have some work cut out for yourself. How to restore individual dbx f...