inputboxenter

Hi How can I make the second marco print out the values from the first macro? for example I want to use the second marco to msg out x and y which are variable in first macro. Thank you so much. Sub myinputbox() 'to use msgbox Dim x As Integer Dim y As String x = InputBox("enter...

Hello I'm new to VBA and I've put the following code in the VBA editor which I've got from a tutorial: Public Sub Mijneersteprogramma() Range("B2").Select ActiveCel.Value = InputBox("Enter Waarde") Range("B3").Select Actievcel.Value = InputBox("Enter Waarde") Range("b4").Select ActiveCel.Value...

Hi The code below opens the other workbook but does not copy the sheet. I got run-time error 9 message. Thank you so much. Sub sheet_copy_diff_wb() 'to copy sheet to different wb Dim x As Integer Dim s As String x = InputBox("enter sheet# you want to copy") s =...

I'm attempting to look at a user defined range to see which rows sum to zero and then hide those rows. It hides the first row, but doesn't move on to the next rows. Where did I go wrong? Using Excel 2016. Dim rng As Range Dim row As Range Dim cell As Range Dim FRow As Integer Dim LRow As...

im trying to create some code which will request input from the user for the day and shift (i have this much done). then copy data from another page and paste it in the appropriate variable location based on those inputs sent through an index/match function. Ex: If user inputs 2 for day and 1...