Text box input based on a combo box selection
I have an inventory input form that has a combo box from which the
user selects the shift for which the inventory is being taken. On
this form I also have a sub form from which separate data is gathered
from the user, but the shift information is also needed. The form and
subform are bound to separate tables. I am using a subform to gather
the additional information to a separate table because the results are
used in a separate calculation. I only want the user to select the
shift information once. How can I populate the "shift" text box on
the subform with the same information ...How do I create a combo box that is tied to another combo box?
I am trying to create a combo box that is associated with yet another combo
box. So, for example, I have a combo list currently, but I'd like another
list (a sub-list) to pop up with each input in the combo list. Is this
Could you live with Data Validation dropdown lists instead of combocbox?
See Debra Dalgleish's site for how-to and a sample workbook.
Gord Dibben MS Excel MVP
On Wed, 9 Dec 2009 10:26:03 -0800, rosamaria <rosamaria
>I am trying to create a com...Combo Boxes in Charts
I have created a chart which includes a combo box which refers to a list
of names. The problem is that the font size is too small - size 10 - and
I would like to make it bigger. Have tried changing the font size of the
data range for the combo box but this has no effect. The properties of
the combo box let me change its size but not the font size of the list
Shirley Munro's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=83...Largest text box
I have 3 text boxes on my form and I need to find the largest number among
I tried =max([txt1],[txt2],txt3]) but this is obviously wrong. How can I do
Thanks for all help offered!
If .txt 1 > .txt2 And .tx1 > txt3 Then
'Txt1 is greatest
ElseIf .txt2 > .txt1 And .txt2 > .txt3 Then
'Txt2 is greatest
'txt3 is greatest
Dave Hargis, Microsoft Access MVP
"Johnny Bright" wrote:
> Hi there!
> I have 3 text boxes ...Publisher is adding a white box around a picture
I am doing a catalog merge in Publisher. I use EPS to inport into the
document. The pictures do not have a border around them but after I pdf out
of publisher and open in corel x4 there is a white square border around the
picture. I have checked the printer settings and don't see anything checked
there. Also in formatting it is set to have no border?? Thanks!
Have you considered .png? Are looking for the.eps. to have a transparent
background? Are you importing into Corel as an Ecapsulated Postscript or
Postscript Interpreted? Usually the latter will have a transparent backgroun...Alignment of Combo Boxes
After creating a template form in Excel with multiple combo boxes I have
discovered they are not uniform ( inline, straight). Can someone
suggest a quick easy way to align the combo boxes on my form?
Thanks- Shari in PA.
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
If you hold down the Alt key on the keyboard as you create the combobox, it
will "snap" to the corners of the cells on the sheet. The Alt key also snaps
the object if you're moving it a...Rules on Additional mail boxes
I am using outlook 2000. And I have configured an
additional mailbox in the Microsoft exchange server
And now I am able to view mails sent to my id as well as
to my group id(additional mail box).
But I am not able to set any rules for the mails to my
additional mail box (like notification messages when a new
mail arrives, etc)..
Please let me know how to set rules (client rules) for the
Thanks in advance
...List, Combo Box, and or Group Opitions
Is there a way to allow user to select mutliple choices like with a Look Up
Field? This can be for either Form (data enter) or table. The data I am try
in to collecte involves whether a client is currently using 1 or more
applications. I do not want to have to dedicate a whole field to 1 data field.
Thanks for your help
You can have a multi-select list box. I do not understand what you mean by
dedicating a whole field to 1 data field.
What is supposed to happen after selecting the item(s)?
>Is there a way to allow user to select mutliple choices like w...Voting Buttons -- Missing drop-down box in Tracking tab
I have a user on Office 2003 who uses voting buttons in Outlook.
She claims that on the Tracking tab of her sent message, a drop-down box
should appear at the right side of each user's "response" column showing the
voting options -- for her to manually populate if the respondent verbally
replies to her.
Our outlook 2003 does not have this. I can find nothing on it. What is she
talking about, and how can I set up this feature for her?
I think she's wrong. That function exists in a Meeting's Tracking table,
not a vote related tracking table from an em...Message Box Font
Is there a way to change the size of the font on a message box?
I am looking for an alternative to creating a popup form for each message.
Thanks in advance for any help
A custom popup form for each message?
Just create one form, and use it for all messages.
Pass the message in (say) OpenArgs, and in Form_Open assign it to the
unbound text box (or label Caption) to display the message.
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Tom Ventouris&qu...Linking textboxes with option boxes
I have a userform with a column of text boxes (TextBox1, 2, 3...10) and
adjacent Check boxes (CheckBox1, 2, 3...10).
The textboxes are populated from a sheet with various items.
What I need is for the adjacent Check boxes to be checked if the textboxes
contain either the text AAAAA or BBBBB and unchecked for anything else.
Can anyone help?
And contains means that the textboxes can contain: xxxxxAAAAAyyyyy
and still be checked, right?
I only used 3 textboxes/checkboxes in this sample. You'll have to add 7 more
Option Expl...Need HELP: Change the size of Message Boxes in Office XP
I need increase the sise of font in Message Boxes in
I increased the size of Message Boxes in Windows, but it
not applayed on Office Message Boxes.
Can you propose me something else?
...Moving Exchange 2003 from one box to another #2
This is a multi-part message in MIME format.
Any pointers/whitepapers in moving Exchange installation along with =
mailboxes and public folders from one box to another? Second box will =
have it's own unique name and original box will still stay there with =
Exchange services disabled.
<!D...Change default location of pop up message box
I want to attach a message to the cell that pops up when
the cursor is positioned over the cell. I have created
the message and when I hold the cursor over the cell the
message displays correctly. However, the problem is that
because I have "frozen" rolls and columns (to keep the
columns descriptions in view when scrolling through the
worksheet) that the "frozen" lines show up in the message
Is there anyway to move the location of the message box
when you hold the cursor over it. I already know how to
move the location of the message box when you...BUG: CArchive exception: badClass
When using CMapStringToOb to serialize the object elements to disk from
inside an MFC DLL, the following error occurs:
Warning: Cannot load CDAFilter from archive. Class not defined.
CArchive exception: badClass.
First-chance exception at 0x77e73887 in DA.exe: Microsoft C++ exception:
CArchiveException @ 0x0012e74c.
It appears that this was a know bug for Visual Studio .NET 2002
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q322621 but why has
it still not been fixed in Visual Studio .NET 2003 ??
If i move the exact same source code to outside the DLL it works perfectly.
I have excel 2000 when I copy a section of a spread sheet
and then paste to my email. The user I send to just double
click the section and they get the whole sheet. Is there a
way to just give that section without copy and paste to a
new sheet then save it.
have a look at
> I have excel 2000 when I copy a section of a spread sheet
> and then paste to my email. The user I send to just double
> click the section and they get the whole sheet. Is there a
> way to just give...Text box in drawing toolbar in Excel
Once I created a text box, I would like to delete the border so it shows only
the text and no border when printing.
select the textbox, right click the border, select format text box, select
colors and lines, in the dropdown for the line area select a white colour
Excel 95 - Excel 2007
Nothwest Excel Solutions
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
"B.W." <BW@discussions.microsoft.com> wrote in message
news:FBE4CD94-3D3D-4E32...Checking a Check Box in Excel
How do I check a check box in Excel. I need to know what to put in
Private Sub CheckBox1_Click()
'this bit here'
Message posted from http://www.ExcelForum.com
Private Sub CheckBox1_Click()
if checkbox1.Value = True then
msgbox "box is checked"
msgbox "box is not checked"
"Frenchie" <Frenchie.firstname.lastname@example.org> wrote in message
> How do I check a check box in Excel. I need to know what to put in
> Private Sub CheckBox1_...Wierd Chinese Characters in Response Box
Running MS Office 2003 Professional. The spelling
checker does not seem to work properly when I am
composing email. Only if I look at it in the "Outbox"
will the mispelled words be highlighted.
When I went into Outlook > Tools > Options > Spelling >
AutoCorrect Options (here all boxes are checked) > then
click on the "OK" button I get a response box that is
full of Chinese (?) characters with an "OK" button.
What is that all about?
Thanks in advance for your response.
...how to make a document with square boxes to add numbers into?
I need to know how to make a document with square boxes to add text. A letter
per box. Like an application.
Insert tab / Tables group / Table button
If my comments have helped please hit Yes.
> I need to know how to make a document with square boxes to add text. A letter
> per box. Like an application.
...Word bug: http hyperlinks to pdf docs open in IE, not default browser
In Word 2003 SP3, hyperlinks to PDF documents open in Internet
Explorer, even though IE is not the system default browser. An
adjacent hyperlink to a ".html" file in the same Word document opens
in Firefox, as appropriate.
This is a duplicate of an unresolved bug from Word 2002, reported here
(as one of many archives for this group)
Have you been into Control Panel | Program and Features | Turn Windows
features on or off and disabled IE?
Terry Farrell - MSWord MVP
"WBT"...Hide my combo boxes!
I have a form with some combo boxes and a group box at the bottom,
the combo boxes and group box are within the section that I want to
hide, but when I select the rows to hide, the cells disappear but the
group box and combo boxes don't .
hays4's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28069
View this thread: http://www.excelforum.com/showthread.php?threadid=482783
On the Toolbar click on the Design Mode icon, Right click combobox you
want to disappe...Combo Lists
I have a database which captures colleagues requesting projects from our
department. Everything work fine, and now I am just tweeking it before it
What I want to know is whether I can create a combo list that is generated as
records are created?
For instance there is a field for the colleagues name, but it would take me
forever to put everyone's name in, so what I wanted to do was if they request
more projects instead of having to enter their names over and over again, can
i just pick it from a previoue entry?
Hope that makes sense
Message posted via http:/...Bug with CHtmlView in VC7
To produce this bug, create a MDI app based on CHtmlView in VC7 with
appwizard. In, CMyView::OnInitUpdate(), Change the default URL to this
Run the app, click the "Push to create" button after the web page
loads. You will see a modeless dialog pops up. Close the view window
and you see the modeless dialog is left unclosed.
In VC6, the dialog is closed automatically when the view is closed.
Thanks for sharing any information regarding this bug.
...Filling a List Box in Excel from an Array
Hope someone can help. I have a listbox in excel which I am trying to
populate from an array. The array is picking up certain values from a sheet
depending on a previous value selected in another list box. I currently have
the array code in a module.
As an example
For i = LBound(ary) To UBound(ary)
(remove nothere from the email address if mailing direct)
"Martin" <Martin@discussions.microsoft.com> wrote in message
> Hope someone ...