visual basic prompt data entry
How can I get visual basic to prompt the user for a data entry that will
subsequently be used in an autofilter. |
visual basic prompt data entry
You use an inputbox statement.
Sub aa() Dim Answer As String answer = InputBox("Enter Criteria", "Filter input") Selection.AutoFilter Field:=1, Criteria:=answer End Sub Hopes this helps. --- Per "BG Mark" skrev i meddelelsen ... How can I get visual basic to prompt the user for a data entry that will subsequently be used in an autofilter. |
visual basic prompt data entry
Dim myStr as string
.... mystr = inputbox(Prompt:="Please enter something") if trim(mystr) = "" then msgbox "you didn't enter anything" else msgbox mystr & " was entered" end if BG Mark wrote: How can I get visual basic to prompt the user for a data entry that will subsequently be used in an autofilter. -- Dave Peterson |
All times are GMT +1. The time now is 02:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com