Posts

Showing posts with the label word-vba

Microsoft Form - If Checkbox Cell Value Greater Than

Image
Clash Royale CLAN TAG #URR8PPP Microsoft Form - If Checkbox Cell Value Greater Than First post on this forum - I have a fillable form which I would like to do the following. There are two check boxes, (Legacy form item), labelled H and N, depending on which one is selected the value of another input box (Legacy form item) should be equal to or greater than a value. E.G if N is selected, the input cell should be greater than 0.5 if H is selected the cell should be equal to or greater than 0.5. Can anyone impart any wisdom on this one, I would then set it to run a check once the user has input the value, based on the checkbox option and value input into the cell. Thanks in advance, Daniel By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Connection Word --> Excel with VBA

Image
Clash Royale CLAN TAG #URR8PPP Connection Word --> Excel with VBA I'm currently working on a project within my company to create a link between Word and Excel. There are different cells in excel which should be visible in word. These cells need to be updated in Word whenever they change in Excel. I know, this isn't much of a problem because MS office does support this by creating a link between those two files. This works fine but the problem is all the documents are stored in a CRM system called Efficy. A person who works for efficy created a tool so the two documents which need to be linked are opened simultaneously in a folder. The folder is called for example "Test folder - 21001". The name of the folder changes per project in the CRM system. So if i open another project it will be called "Test folder - 21002" for example. Is it possible to create a link between Word and Excel which is always the current folder of the Word document? The excel file alw...