marilynstephan
New Member
- Joined
- Aug 20, 2009
- Messages
- 12
Am trying to create a macro that will launch a user form, allow the user to select a value from column A and then have the values on that line displayed.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
<o
></o
>
My simple table looks like this. The top line is a heading<o
></o
>
<o
></o
>
<TABLE class=MsoNormalTable style="MARGIN: auto auto auto -0.75pt; WIDTH: 721pt; BORDER-COLLAPSE: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0in 5.4pt 0in 5.4pt" cellSpacing=0 cellPadding=0 width=961 border=0><TBODY><TR style="HEIGHT: 18.75pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes"><TD style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #d4d0c8; WIDTH: 247pt; PADDING-TOP: 0in; BORDER-BOTTOM: #d4d0c8; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=329>Specialty<o
></o
>
</TD><TD style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #d4d0c8; WIDTH: 232pt; PADDING-TOP: 0in; BORDER-BOTTOM: #d4d0c8; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=309>Words<o
></o
>
</TD><TD style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #d4d0c8; WIDTH: 242pt; PADDING-TOP: 0in; BORDER-BOTTOM: #d4d0c8; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=323>Words2<o
></o
>
</TD></TR><TR style="HEIGHT: 18.75pt; mso-yfti-irow: 1"><TD style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #d4d0c8; WIDTH: 247pt; PADDING-TOP: 0in; BORDER-BOTTOM: #d4d0c8; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=329>Allergy and Immunology<o
></o
>
</TD><TD style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #d4d0c8; WIDTH: 232pt; PADDING-TOP: 0in; BORDER-BOTTOM: #d4d0c8; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=309>allergy jobs<o
></o
>
</TD><TD style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #d4d0c8; WIDTH: 242pt; PADDING-TOP: 0in; BORDER-BOTTOM: #d4d0c8; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=323>immunology jobs<o
></o
>
</TD></TR><TR style="HEIGHT: 18.75pt; mso-yfti-irow: 2"><TD style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #d4d0c8; WIDTH: 247pt; PADDING-TOP: 0in; BORDER-BOTTOM: #d4d0c8; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=329>Anesthesia Assistant<o
></o
>
</TD><TD style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #d4d0c8; WIDTH: 232pt; PADDING-TOP: 0in; BORDER-BOTTOM: #d4d0c8; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=309>anesthesia assistant jobs<o
></o
>
</TD><TD style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #d4d0c8; WIDTH: 242pt; PADDING-TOP: 0in; BORDER-BOTTOM: #d4d0c8; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=323>anesthesia assistant job<o
></o
>
</TD></TR><TR style="HEIGHT: 18.75pt; mso-yfti-irow: 3; mso-yfti-lastrow: yes"><TD style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #d4d0c8; WIDTH: 247pt; PADDING-TOP: 0in; BORDER-BOTTOM: #d4d0c8; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=329>CRNA<o
></o
>
</TD><TD style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #d4d0c8; WIDTH: 232pt; PADDING-TOP: 0in; BORDER-BOTTOM: #d4d0c8; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=309>Certified registered Nurse Anesthetist<o
></o
>
</TD><TD style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #d4d0c8; WIDTH: 242pt; PADDING-TOP: 0in; BORDER-BOTTOM: #d4d0c8; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=323>Nurse Anesthetist<o
></o
>
</TD></TR></TBODY></TABLE><o
></o
>
I would like the users to be able to select a specialty from a drop down box (filled with the items in column A “Specialty") and then have a screen in front of them display the Specialty with the other words from the cells to the right of the Specialty chosen, (I'd like those words displayed vertically under the specialty.()
<o
></o
>
Can you help me please. My table is a large one with 175 Lines (specialties) and 15 columns to the the right on the specialty column (total of 16 Columns of Words, not all of them filled).<o
></o
>
<o
></o
>
Actually I defined the range of the table, used the “form” command, and using the criteria button, got exactly what I wanted. Unfortunately, my users are not saavy enough to use the forms command and then the criteria button.
Any ideas?<o
></o
>
<o
My simple table looks like this. The top line is a heading<o
<o
<TABLE class=MsoNormalTable style="MARGIN: auto auto auto -0.75pt; WIDTH: 721pt; BORDER-COLLAPSE: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0in 5.4pt 0in 5.4pt" cellSpacing=0 cellPadding=0 width=961 border=0><TBODY><TR style="HEIGHT: 18.75pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes"><TD style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #d4d0c8; WIDTH: 247pt; PADDING-TOP: 0in; BORDER-BOTTOM: #d4d0c8; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=329>Specialty<o
</TD><TD style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #d4d0c8; WIDTH: 232pt; PADDING-TOP: 0in; BORDER-BOTTOM: #d4d0c8; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=309>Words<o
</TD><TD style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #d4d0c8; WIDTH: 242pt; PADDING-TOP: 0in; BORDER-BOTTOM: #d4d0c8; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=323>Words2<o
</TD></TR><TR style="HEIGHT: 18.75pt; mso-yfti-irow: 1"><TD style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #d4d0c8; WIDTH: 247pt; PADDING-TOP: 0in; BORDER-BOTTOM: #d4d0c8; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=329>Allergy and Immunology<o
</TD><TD style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #d4d0c8; WIDTH: 232pt; PADDING-TOP: 0in; BORDER-BOTTOM: #d4d0c8; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=309>allergy jobs<o
</TD><TD style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #d4d0c8; WIDTH: 242pt; PADDING-TOP: 0in; BORDER-BOTTOM: #d4d0c8; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=323>immunology jobs<o
</TD></TR><TR style="HEIGHT: 18.75pt; mso-yfti-irow: 2"><TD style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #d4d0c8; WIDTH: 247pt; PADDING-TOP: 0in; BORDER-BOTTOM: #d4d0c8; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=329>Anesthesia Assistant<o
</TD><TD style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #d4d0c8; WIDTH: 232pt; PADDING-TOP: 0in; BORDER-BOTTOM: #d4d0c8; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=309>anesthesia assistant jobs<o
</TD><TD style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #d4d0c8; WIDTH: 242pt; PADDING-TOP: 0in; BORDER-BOTTOM: #d4d0c8; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=323>anesthesia assistant job<o
</TD></TR><TR style="HEIGHT: 18.75pt; mso-yfti-irow: 3; mso-yfti-lastrow: yes"><TD style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #d4d0c8; WIDTH: 247pt; PADDING-TOP: 0in; BORDER-BOTTOM: #d4d0c8; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=329>CRNA<o
</TD><TD style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #d4d0c8; WIDTH: 232pt; PADDING-TOP: 0in; BORDER-BOTTOM: #d4d0c8; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=309>Certified registered Nurse Anesthetist<o
</TD><TD style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #d4d0c8; WIDTH: 242pt; PADDING-TOP: 0in; BORDER-BOTTOM: #d4d0c8; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=323>Nurse Anesthetist<o
</TD></TR></TBODY></TABLE><o
I would like the users to be able to select a specialty from a drop down box (filled with the items in column A “Specialty") and then have a screen in front of them display the Specialty with the other words from the cells to the right of the Specialty chosen, (I'd like those words displayed vertically under the specialty.()
<o
Can you help me please. My table is a large one with 175 Lines (specialties) and 15 columns to the the right on the specialty column (total of 16 Columns of Words, not all of them filled).<o
<o
Actually I defined the range of the table, used the “form” command, and using the criteria button, got exactly what I wanted. Unfortunately, my users are not saavy enough to use the forms command and then the criteria button.
Any ideas?<o