need variable for range instead of cell

[DonaldT]

I have a userform with, at this time 93 textboxes, checkboxes, and option buttons. I have coded the values from these objects to a worksheet named inputs.

Inputs.Range("C4").Value = txName.Value

I need to change C4 to a variable so that each time I save my form it moves one column over. I want to start at C4, save my values, move to D4, save my values, etc.
This is what I have:
[code]
Dim opencell As String
Inputs.Activate
Inputs.Range("C4").Activate
Do Until IsEmpty(ActiveCell.Value)
ActiveCell.Offset(0, 1).Select
Loop
opencell = ActiveCell.Address

Inputs.Range("opencell ").Value = txName.Value
[code]
And I get run time error 1004
Method ‘Range of object’_Worksheet’ failed
Any help would be appreciated.
Thank you

[alansidman]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[DonaldT]

there is no # icon at the top of my post window

[DonaldT]

also I get a web attack nuclear exploit kit form Norton

[alansidman]

Please see the pictureCapture.PNG
This is while you are in the edit/response mode.

[DonaldT]

well Sir I must be doing something I RMB click and then LMB click the show picture and nothing happens

[jindon]

DonaldT

Edit you first post and add / to 2nd [noparse][code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]

[DonaldT]

thanks I will try that
as far as edit my post, I click on the edit button and the entire post is erased. I use the back arrow to get out of the edit and it returns as is.
I tried to copy the entire post and paste it back, then edit and save , still blank.
I'm not very good at this it would seem

[DonaldT]

that worked thank you. how can I use cell offset and move 1 row down

Please Login or Register  to view this content.

[alansidman]

Since this thread has gone on without you being able to edit the post, I will close this. Please start a new post and do use code tags when you do.