Excel userform populates date in word bookmark

D

Desmondo

Board Regular
Joined
Feb 27, 2013
Messages
70
Hi this little problem has been driving me bonkers for days. I have a userform which populates word docs and an excel form with various bits of information. Dates amounts etc. At present the dates age transferred like this 29/01/76 on one of the word letters g would like it to be 29th Jan 2017. Is there away of doing this from excel or word?
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
You must log in or register to reply here.

Similar threads

A
  • Solved
Using VBA to loop through multiple Word Templates and fill them in with Excel Data
2
Replies
14
Views
1K
John_w
J
C
  • Question Question
Replacing PowerPoint Input using Find and Replace Arrays from Excel through VBA
Replies
0
Views
2K
ckcs
C
F
  • Solved
VBA Code to Open a Word Template and Delete Bookmarks and Enclosed Text Based on the Value in Excel Cells
Replies
5
Views
4K
Fromlostdays1
F
T
  • Question Question
Create a Macro to Export a PDF file from Excel data and bookmarks
Replies
0
Views
2K
TheNewVbaDev
T
L
  • Question Question
Userform to populate data in multiple sheets
Replies
1
Views
1K
lplexe
L

Forum statistics

Threads
1,223,214
Messages
6,170,771
Members
452,353
Latest member
strainu

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top