myvalue

Hello, how do I ensure myValue when entered in the inputbox in the first sub below, carries through to the section without being asked again? Many thanks. Sub D42_Forecast_Macro() Dim myValue As Variant myValue = InputBox("Enter the railway period, e.g. 1804") End Sub Public Sub...

Hello, I'd like to select the file from the value I have already inputted into my input box previously, this codes doesn't seem to work. Workbooks.(" & myValue & ".xlsx").Select Can anyone help please? Many thanks.

Hello, I use email subs routinely to pass WS/WB information around all the time. A request was generated that I add in a function so that users could send me a note about comments or suggestions on how certain WB's are working for the users; kind of like a "contact the webmaster" kind of thing...

Sub Clean_Data() Dim myValue As Variant Dim myValue2 As Variant Application.ScreenUpdating = False Application.DisplayAlerts = False Dim FP As String, FN As String myValue = InputBox("Enter the railway period, e.g. 1804") myValue2 = InputBox("Enter the date you wish to clean the data in...