-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
wsmysheet
-
K
How to get this userform to work on another sheet
Hi, I use this userform that works great on the sheet named PRODUCTs that we type our product names directly into column F. <code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height: 12px;">Option Explicit Private Sub UserForm_Initialize() Dim...- kandso
- Thread
- dim end set sheet wsmysheet
- Replies: 8
- Forum: Excel Questions
-
K
How to input decimal places with this userform
Hi, New here and I took over using a workbook at my company and I'm trying to learn VBA to make some changes. One of the issues is with this userform code that we use to add part order quantities, it works great except for it only inputs a whole number in the cells. As an example if I input...- kandso
- Thread
- dim end input set wsmysheet
- Replies: 2
- Forum: Excel Questions
-
L
How to copy format and value only?
The VBA below can form a new sheet and then copy used range of existing sheet to this new sheet. Sub yMacro1() Dim wsNewSheet As Worksheet Dim wsMySheet As Worksheet Set wsNewSheet = Sheets.Add(Before:=Worksheets(1)) For Each wsMySheet In ThisWorkbook.Sheets...- London12F
- Thread
- copy dim sheet worksheet wsmysheet
- Replies: 2
- Forum: Excel Questions
