I need some help with a keyword search function. I have a button that when the user hits it, an InputBox appears asking for their keyword they would like to search. I need the results displayed in Listbox1.
I'm having 2 problems right now.
1. The code below is returning an error that says...
I have a line of code that displays the selections the user makes in a combobox to a textbox. It separates each selection with a comma.
Here's the code:
ActiveDocument.FormFields("Text1").Result = temp & ", " & ComboBox1.Value
The result will display as:
I would like to have a new line...
I'm hoping you guys can help me with a simple loop problem. I have some VB code that takes a particular range of cells and copies and pastes them into a Word doc as a picture. The users have the ability to show and hide rows as needed in the worksheet. I need to just pick up the first 45...
Right now I have code that selects a particular range of cells and it copys and pastes those cells in a Word doc. Then it goes onto my next range of cells and does the same thing and so on.
The problem is that because users need to hide various rows, the length of the page changes.
I need to...
I'm having a problem pasting from Excel to Word. I paste cells A1:F63 as a picture with no problem. When I copy and paste cells A64:F267, it pastes over my first picture. I haven't been able to successfully move to the end of the document or add a page break then paste the 2nd set of cells...
I'm having a problem pasting from Excel to Word. I paste cells A1:F63 as a picture with no problem. When I copy and paste cells A64:F267, it pastes over my first picture. I haven't been able to successfully move to the end of the document or add a page break then paste the 2nd set of cells...
Hi,
I need help converting one sheet in excel to a .doc file. I've created a letter in Excel that contains our company logo and the text of the letter. I was trying to copy the first 6 rows of the letter as a "picture" in word (that's where the logo is). Then paste the remaining rows as text...
Below is my code to copy data from a worksheet to a Word Doc. The problem I'm having is that it seems to be copied as a picture or text box. Instead of it pulling in cells A1:F301 as stated in the code, only cells A1:F70 are showing in the .doc file.
My data takes up about 6 pages in Word so...
Below is my code to copy data from a worksheet to a Word Doc. The problem I'm having is that it seems to be copied as a picture or text box. Instead of it pulling in cells A1:F301 as stated in the code, only cells A1:F70 are showing in the .doc file.
My data takes up about 6 pages in Word so...
I have a need to feed data from a letter in one Word doc to a letter in another Word doc file. Is this possible? When I try to use the Mail Merge feature in Word it wants a data source like Excel, Access, or a table in Word. I need to feed from one letter to another.
For example, a user...
I'm trying to write some code in VB for an Access Database. I'm writing a procedure that updates the selection available for a Combobox based on selections from 2 other Comboboxes. However, the tricky part for me is the "OR" piece. The user does not have to make selections for both comboboxes...
I need help writing a query using multiple combobox selections. I've done this successfully for one combobox. The part I'm having a problem with is having the query "ignore" comboboxes where the user doesn't make a selection and leaves it blank.
For Example:
I have 4 comboboxes on a form...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.