I'm so glad to hear that! Yes, I actually have a TH-cam Course on How to Create Fillable Forms in Microsoft Word: th-cam.com/play/PLb80efKTbWuNzAyHVMYrPOS7itBm5gWVs.html You are welcome to watch the intro video and then if interested, it is a paid course on TH-cam and you can access a course workbook PDF and the sample form templates to go along with it. I'm glad you like my videos and that they have helped you out at work. I wish you the best! Thanks for watching my Channel!
Hi Sharon I watched your Fila Le forms for Mac and the one for reset button. I am just wondering how do you create the reset button and submit button in one button in Mac . Mac version does not have the legacy tool and I have been unable to add it in. Your help would be appreciated. Thanks Michael
Hello Michael! Thanks for watching my videos. Word for Mac does not natively support the same level of form control functionality as Word for PC, including the insertion of a Submit button directly within the document. However, there are some workarounds and alternative approaches you can consider: Macro-Enabled Documents: You can create a macro that performs a similar function to a Submit button. This would involve writing a VBA (Visual Basic for Applications) macro that handles the submission process. On Word for Mac, you can create and run macros, but the process to set them up and use them might be more complex compared to Word for PC. Online Forms: Use Microsoft Forms or Google Forms to create an online form and include a link to this form in your Word document. This can serve as a substitute for a Submit button. Here is my video on how to create Online forms with Microsof Forms: th-cam.com/video/VMrGTMy2gaM/w-d-xo.html Here is my video on how to create Online forms with Google Forms: th-cam.com/video/VBFOOC8enVI/w-d-xo.html Hope this helps!
Hello! The "ambiguous name error" in VBA typically occurs when there are multiple objects with the same name in the project, causing VBA to be unsure which one you're referring to. To fix this issue, you can try one or more of the following steps: 1. Rename the Subroutine: Change the name of the subroutine CommandButton1_Click to something unique. For example: Private Sub ResetFormButton_Click() 2. Ensure Unique Object Names: Make sure there are no other objects (such as buttons or shapes) with the same name CommandButton1 in your Word document. If there are, you can rename them to ensure uniqueness. 3. Explicitly Qualify the Object: If you have multiple modules or objects with similar names, you can explicitly qualify which one you're referring to. For example: Private Sub UserForm1_CommandButton1_Click() This approach specifies the user form (UserForm1) that contains the command button. Make sure to replace UserForm1 with the actual name of your user form. After making these changes, ensure you update the references to the subroutine throughout your code to match the new name. I hope this helps! Thanks for watching my videos!
Hello! Hopefully you found it in the video description. If you are on mobile, you have to expand it below the video - it is a little easier to find on desktop. Hope this helps! Thanks for watching!
Muito bom esse codigo pra ficar ainda melhor deveria exibir uma caixinha perguntando se a pessoa gostaria realmente de apagar o conteudo ou nao. 'Ficaria dessa forma: Dim Resposta As VbMsgBoxResult Dim cc As ContentControl Dim ff As Field
Resposta = MsgBox("Deseja apagar todos os campos preenchidos?", vbYesNo, "Aviso") 'So executa se a resposta for afirmativa, caso contrario sai da rotina If Resposta = vbNo Then Exit Sub Else 'Desprotege o documento para limpar os campos do formulario If ActiveDocument.ProtectionType wdNoProtection Then ActiveDocument.Unprotect End If 'Limpa o conteudo do campos do formulario For Each cc In ActiveDocument.ContentControls Select Case cc.Type Case wdContentControlText 'Caixa de texto cc.Range.Text = "" Case wdContentControlComboBox 'Caixa de Combinação cc.Range.Text = "" Case wdContentControlDate 'Caixa de datas cc.Range.Text = "" Case wdContentControlCheckBox 'Caixinhas de seleção cc.Checked = False End Select Next cc
'Reseta legacy form Fields ActiveDocument.ResetFormFields 'Protege o documento If ActiveDocument.ProtectionType = wdNoProtection Then ActiveDocument.Protect Type:=wdAllowOnlyFormFields, NoReset:=True End If End If
You are a life saver!!!!! I have been looking for this type of info for a long time
So glad you found it helpful! Thanks for watching!
sharon , always amazing , thanks for this video
I'm so glad you found it helpful! Thanks so much for watching my videos!
Great video!
Thanks Linda!
Your video has been a huge help with my work project. I would love take classes from you to further my knowledge in form making. Do you offer classes?
I'm so glad to hear that! Yes, I actually have a TH-cam Course on How to Create Fillable Forms in Microsoft Word: th-cam.com/play/PLb80efKTbWuNzAyHVMYrPOS7itBm5gWVs.html You are welcome to watch the intro video and then if interested, it is a paid course on TH-cam and you can access a course workbook PDF and the sample form templates to go along with it.
I'm glad you like my videos and that they have helped you out at work. I wish you the best! Thanks for watching my Channel!
@@SharonSmith Do you have a price for the whole series or are you only selling them per course?
This was awesome, thank you! When I reset my form my text box calculation field doesn't reset. Would add'l code be needed?
Hi Sharon
I watched your Fila Le forms for Mac and the one for reset button. I am just wondering how do you create the reset button and submit button in one button in Mac . Mac version does not have the legacy tool and I have been unable to add it in.
Your help would be appreciated.
Thanks
Michael
Hello Michael! Thanks for watching my videos. Word for Mac does not natively support the same level of form control functionality as Word for PC, including the insertion of a Submit button directly within the document. However, there are some workarounds and alternative approaches you can consider:
Macro-Enabled Documents:
You can create a macro that performs a similar function to a Submit button. This would involve writing a VBA (Visual Basic for Applications) macro that handles the submission process.
On Word for Mac, you can create and run macros, but the process to set them up and use them might be more complex compared to Word for PC.
Online Forms:
Use Microsoft Forms or Google Forms to create an online form and include a link to this form in your Word document. This can serve as a substitute for a Submit button.
Here is my video on how to create Online forms with Microsof Forms: th-cam.com/video/VMrGTMy2gaM/w-d-xo.html
Here is my video on how to create Online forms with Google Forms: th-cam.com/video/VBFOOC8enVI/w-d-xo.html
Hope this helps!
Is there a way to customize where some of the drop boxes stay on a certain item as a default even after you reset?
Sharon, how do I put a "insert a blank page" command button so that when it's clicked, a new blank page is added?
I added the command button but when i double click it says Project is Unviewable?
I am getting a ambiguous name error with this line: Private Sub CommandButton1_Click. Is there a way to fix?
Hello! The "ambiguous name error" in VBA typically occurs when there are multiple objects with the same name in the project, causing VBA to be unsure which one you're referring to. To fix this issue, you can try one or more of the following steps:
1. Rename the Subroutine: Change the name of the subroutine CommandButton1_Click to something unique. For example:
Private Sub ResetFormButton_Click()
2. Ensure Unique Object Names: Make sure there are no other objects (such as buttons or shapes) with the same name CommandButton1 in your Word document. If there are, you can rename them to ensure uniqueness.
3. Explicitly Qualify the Object: If you have multiple modules or objects with similar names, you can explicitly qualify which one you're referring to. For example:
Private Sub UserForm1_CommandButton1_Click()
This approach specifies the user form (UserForm1) that contains the command button. Make sure to replace UserForm1 with the actual name of your user form.
After making these changes, ensure you update the references to the subroutine throughout your code to match the new name.
I hope this helps! Thanks for watching my videos!
@@SharonSmith It worked! Thank you.
@@maxeenandjasminehill1542 Awesome! Glad to hear it!
I cannot get this to work. I'm so frustrated. I'm not sure what I'm doing wrong.
How do you add a drop down list reset?
I do not see where we can copy the active X commands
Never mind
Hello! Hopefully you found it in the video description. If you are on mobile, you have to expand it below the video - it is a little easier to find on desktop. Hope this helps! Thanks for watching!
Hoping you found it in the video description. Take care!
Why it seems like a repeated code? It prompted error on mine and only work when I cut the half of it.
Muito bom esse codigo pra ficar ainda melhor deveria exibir uma caixinha perguntando se a pessoa gostaria realmente de apagar o conteudo ou nao.
'Ficaria dessa forma:
Dim Resposta As VbMsgBoxResult
Dim cc As ContentControl
Dim ff As Field
Resposta = MsgBox("Deseja apagar todos os campos preenchidos?", vbYesNo, "Aviso")
'So executa se a resposta for afirmativa, caso contrario sai da rotina
If Resposta = vbNo Then
Exit Sub
Else
'Desprotege o documento para limpar os campos do formulario
If ActiveDocument.ProtectionType wdNoProtection Then
ActiveDocument.Unprotect
End If
'Limpa o conteudo do campos do formulario
For Each cc In ActiveDocument.ContentControls
Select Case cc.Type
Case wdContentControlText 'Caixa de texto
cc.Range.Text = ""
Case wdContentControlComboBox 'Caixa de Combinação
cc.Range.Text = ""
Case wdContentControlDate 'Caixa de datas
cc.Range.Text = ""
Case wdContentControlCheckBox 'Caixinhas de seleção
cc.Checked = False
End Select
Next cc
'Reseta legacy form Fields
ActiveDocument.ResetFormFields
'Protege o documento
If ActiveDocument.ProtectionType = wdNoProtection Then
ActiveDocument.Protect Type:=wdAllowOnlyFormFields, NoReset:=True
End If
End If
'End Sub
'Thanks Sharon
I appreciate the suggestion! Thanks for watching!