Search results for query: *

I am having trouble with the following code Sub getitems() Dim WSD As Worksheet Dim WSW As Worksheet Dim QT As QueryTable Sheets("Sheet1").Select For m = 1 To Range("C1").Value Select Case m Case Else mystr = m End Select...

Sorry about the title didnt know how to describe what i wanted. So here is my issue I have been asked to design a capacity planning tool and have been throwing around ideas on how to go about it. I have made one before in Excel which worked fine until it came time to add more fields and...

I am new to VBA and am having some trouble with combobox storing numbers as text. The combobox pulls data from a named range in a sheet containing numbers (stored as numbers) the user selects a number and then hits a confirm command button with the following code Private Sub Confirm_Click()...

I have a basic spreadsheet with a named range in a list. what i want to do is protect the sheet but enable the user to add data to the list, i know how to enable users to edit ranges and what not but the issue is when i protect the sheet the list does not expand to have an extra row to input...

Im trying to set a user up with a function key to activate his headset, the phone is a dbc 203 with an option unit attached for the headset, i have been told that the headset function key should activate automatically on key 14. so i deleted the extension and re initiated it but key 14 has gone...