ed to change TextBox1 to text box you desired.
>
> Cheers!!
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Wed, Sep 24, 2014 at 11:18 PM, Mr_Bill >
> wrote:
>
>> Can this code be adapted to work with only certain textboxs? I h
Can this code be adapted to work with only certain textboxs? I have 15
boxes in a form that require a number to be input and all are named wtBox1
- wtBox15
Dim LastPosition As Long
>
> Private Sub TextBox1_Change()
> Static LastText As String
> Static SecondTime As Boolean
> If Not Secon
""", D" & NextRw &
> ", """")"
>
>
> -------
> Now, on to my second question: WHY?
> Do you want the cell (cells(i,2)) to contain
How this works is if data is input in the next available cell in a column
this code sees what cell it was and in another of area of the sheet input
the cell location like =YXX the XX being the cell number. and Y being the
Column
using the nextrw from this line
NextRw = ws.Range("A190").End(
If I understood you correctly this might work for you
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
Dim Days As Integer, result As String
If Target.Address = "$A$2" Then
Days = Range("A2").Value
If Days >= 180 Then
result = "181 days up"
ElseIf Days > 90 Then
result = "91-180
ot clear on what you want! can you explain wirth dummy data in
> sheet2 too.
>
>
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Tue, Sep 9, 2014 at 4:39 AM, Mr_Bill >
> wrote:
>
>> Sample workbook if help to g
Sample workbook if help to get the answer for this
https://www.dropbox.com/s/9ea1r3wfe24oav7/example%20workbook.xlsm?dl=0
On Monday, September 8, 2014 6:47:13 AM UTC-7, Mr_Bill wrote:
>
> I currently have a userform that works perfectly with the first sheet and
> dont want to change tha
I currently have a userform that works perfectly with the first sheet and
dont want to change that. What I would like to do is add one of the pieces
of data into a 2nd sheet that has a different layout. It would be something
like this
*Classwork *
*Drafts *
*Records *
*Portfolio *
*Final *
Have a small code that keeps returning a compile error will highlight the
trouble area hopefully someone can tell me what im doing wrong
Private Sub cmdSubmit_Click()
> Application.ScreenUpdating = False
> Dim NextRw As Long
> Dim ws As Worksheet
> Dim startRow As Long
>
>
> Set w
That works great thank you :)
One more question if I have data in the sheet from column a to e how would
I get this to work with columns G:K starting at row 6
I tried but if the last row of info in column A is row 66 and I edit this
form to work for column G:K it inputs the info at G67 and not
Figure it out Paul that works very nice now I need to get it to start at
row 6 and go down from there.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RUL
Paul thank you for that. What in this would I need to change to match what
you put.
Set ws = Sheet1
lRow = ws.Cells(Rows.Count, 1).End(xlUp).Offset(2, 0).Row
as the IRow part changed. This part gives me the blank row between the sets
but unclear how to edit it to fix with your code.
--
Okay so I tried to do this on my own. Which in someways was good learned
somethings. On the flip side I have aged 30 years and have pulled half my
hair out. I have tried to get the information to input on the form put I
can not get it in how I would like it. It is all going in the same row and
I appreciate the effort but that doesnt work correctly.
On Tuesday, September 2, 2014 8:52:50 PM UTC-7, pramodb35 wrote:
>
> Hi Bill
>
> Please find the attached file .
>
>
> P
>
>
> On Wed, Sep 3, 2014 at 1:17 AM, Mr_Bill >
> wrote:
>
>> I cu
I currently have a macro that works for columns 1:5
I would like to know how would I make the script work with columns 7:11
with 10 being the sortKeyCol.
Not sure what I need to change in the code itself to make it work. Could
someone lend a hand with this please.
Here is a stripped down ver
15 matches
Mail list logo
