Excel - Not Printing Drop Down Arrow

[rnegde]

I have a worksheet that has a drop down list control on it. Is there anyway to set it to where when you print the page, it will print the data chosen from the list, but NOT print the drop down arrow??


I've never seen this done, but I really need to be able to do this.
Any help would be greatly appreciated!!!!

 

[xlbo]

Is your drop down arrow from data validation or a drop down box that has been added to the sheet. If it is a drop down box, is it from the controls toolbox or the forms toolbox ??
Rgds
Geoff HTH
~Geoff~

 

[rnegde]

At this point I can change the page to either one if that is what it takes to make this work. Currently it is a controls toolbox. It really doesn't matter to me about rebuilding the page, as long as I can print it without the arrow being printed.

 

[DaleWatson123321]

Hi rnegde,

With either a ListBox or a ComboBox, here are the steps...

1) First assign range names to your "Input Range" (eg "list_1&quot and your "Cell link" (result_1)

2) In the column to the immediate left of your Input Range, enter values for each item - for example if your list is 8 items, then enter 1 to 8.

3) For this 2-column range, assign another range name, for example call it "table_1"

4) In the cell where you want the result to be printed, enter the following formula (which is based on assigned the above range names - you can use whatever range names you deem appropriate)

=VLOOKUP(result_1,table_1,2)

You can even place this formula "underneath" the ListBox or ComboBox, if this makes sense. Sometimes it is preferable depending on the situation.

5) To prevent the ListBox or ComboBox from printing, do the following:
a) Right-click on the box
b) Click the "Properties" tab
c) Un-check "Print object"

I hope this helps and is what you wanted. Please advise as to how you make out. If you have any questions or difficulty please ask.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[xlbo]

Use the workbook_Beforeprint() event
Pick up the value from the dropdown and put it in the cell behind the dropdown
set the dropdowns visible property to false (forms or controls)
should work. If you need the actual code to do this, I should be able to provide you with it..... on Monday - end of the day now, time to enjoy the weekend
HTH
Geoff HTH
~Geoff~