link commandbuttons on userform and sheet

**cfinch100** · 04-17-2013, 08:20 AM

hi
i have now sorted most of this apart from linking commandbuttons together ,i have cmd1 on frmret,cmd2 on sheet3,cmd3 and cmd4 on frmret,these need to
be done in this order,cmd1 saves to sheet3,then cmd2 combines together,cmd3 then posts to sheet4,cmd4 then deletes,have done the rounds on the forums
and can not figure this one out at all,does any one know the best way to do this please,ideas,pointers anything at all would be gratefully received
cheers colin

**tehneXus** · 04-18-2013, 05:56 AM

Hi,

there is no "cmd1" in your example code, instead you have at least 9 times used "CommandButton1". could you be more specific?

Regards

**cfinch100** · 04-18-2013, 11:33 AM

hi
sorry the buttons are commandbutton1 on frmret,commandbutton2 on sheet3,and commandbutton3 and 4 back on frmret,they need to execute in that order to work
no1 saves,n02 cobines,no3 puts posted in cell and posts all to sheet4,no4 deletes posted rows
hope this explains,also when you run frmret top right boxes picks up name,company,location from sheet3 but only ever picks first line entered if you return another
item that someone else drew out it does not change to suit
hope this explains
many thanks colin

**tehneXus** · 04-18-2013, 11:54 AM

Sooo,

commandbutton1 on frmret

does not exist, instead we have the following buttons there:
- cmdAdd
- cmdUpdate
- CommandButton3
- CommandButton4
- CommandButton5
- CommandButton6
- CommandButton7
- CommandButton8
- CommandButton11
- CommandButton18
commandbutton2 on sheet3

does not exist, there is only "CommandButton1"

Please check the file you uploaded.

Regards

**cfinch100** · 04-18-2013, 01:15 PM

hi
humble apologies i renamed these, but not code headings,again in order cmdadd-------frmret,commandbutton1---------sheet3,commandbuton11----------frmret and commandbutton18------frmret
just not sure if you can switch between userform and sheet and userform again condensing these 4 buttons into one
many thanks colin

**tehneXus** · 04-18-2013, 01:31 PM

hi,

make sure all buttons affected have "Public" in their click event and then use

Sub ClickButtons()

    FRMRET.cmdAdd_Click
    Sheet3.CommandButton1_Click
    FRMRET.CommandButton11_Click
    FRMRET.CommandButton18_Click
    
End Sub

Regards

**cfinch100** · 04-18-2013, 01:42 PM

hi
stops at sheet3. CommandButton1_Click method or data member not found
any ideas cheers colin

**tehneXus** · 04-18-2013, 01:45 PM

make sure all buttons affected have "Public" in their click event

e.g.:

Public Sub Commandbutton1_Click

instead of

Private Sub Commandbutton1_Click

**cfinch100** · 04-18-2013, 01:54 PM

hi
many thanks
not sure what the difference is between public and private,will look it up
many thanks
colin

link commandbuttons on userform and sheet

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

link commandbuttons on userform and sheet

Re: link commandbuttons on userform and sheet

Re: link commandbuttons on userform and sheet

Re: link commandbuttons on userform and sheet

Re: link commandbuttons on userform and sheet

Re: link commandbuttons on userform and sheet

Re: link commandbuttons on userform and sheet

Re: link commandbuttons on userform and sheet

Re: link commandbuttons on userform and sheet

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions